Search results for query: *

I'm running Windows 98, XL97 for a workbook with password protection at VBA ThisWorkbook level. I have a text box contol embedded in a cell with max row height on cell set at 409. Text box format control is set to 'move and size with cells' and PrintObject = True. Properties for text box...

Hello, I'm trying to use the ThisWorkbook.Open() event in an xl97 workbook (code originally written in xl2002) with multiple worksheets to .Protect/.Unprotect the macros running within each worksheet. The macros run correctly on the first fire, but upon the creation (using...

Hello All, Need assistance for MS Access to Outlook XP tasks using Visual Basic....here's the problem: Have a dBase set up that generates reports based on multiple ID's with page breaks separating the distinct records. This report is based on a CLICK event in the form's sub procedure. The...

Hello, I recently found coding on your site that saves a MS Access file to .pdf and then emails it using MS Outlook (see faq703-2533). I have attempted to run my code and keep receiving this MsgBox error "User-defined type not defined" at line: Dim appOutLook As Outlook.Application...

Hello, Working in Excel XP and need assistance with VB coding listed below. Trying to copy the ActiveSheet and rename the sucessive sheets. VB gives me a 'Run-time error' that says, "Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook...

Hello, I need assistance with a compile error that I cannot resolve - "Else without If". The error occurs when the it hits the first 'Else' within "Budget Form (2)" code (see code below). Here's what I'm trying to do: Copy Budget Form to Budget Form 2 if user clicks on...

Problem: The worksheet is comprised of Sheet1 that has calculated fields and macro buttons that: a) add rows to the sheet; and b) should create a copy of Sheet1 properties with the calculated fields (no data, just formulas) to Sheet2. Is there an Excel function that will copy the properties...