Mysterious macro(s)....

[shanefowlkes]

I'm sure this is pretty common but I'm not exactl sure what to search for. I copied a few sheets from an existing workbook that had macros into a NEW blank workbook. No cells or sheets are linked to the original file and everytime I open the new workbook, I'm prompted to "Enable or Disable macros..etc.." even though this new file doesn't seem to contain any VBA. I looked under Tools >> Macros and none are listed in the workbook. I even used the VBA toolbar and looked for any VBA modules or events that could be associated with this new file and nothing was found.

Any ideas on how to get rid of this prompt?

Thanks!

(Excel 2000)

 

[Mark O'Brien]

I have this problem with a lot of workbooks I get sent. There's no real code on the book, but usually some event subroutines somewhere.

Follow these instructions, I hope they'll help

1. Open Excel
2. Press ALT+F11 to open the VBE
3. In the VBA project window you'll see all of the sheetnames for the workbook listed there, plus one for "ThisWorkbook".
4. Double click on the icon for the first sheet. If there is any text in the window that appears then delete it.
5. Repeat step 4 for all of the sheets listed, plus "ThisWorkbook"

HTH

 

[shanefowlkes]

Thanks. No luck. Every single sheet in the VBA editor had nothing associated with it nor did the WB.

D'oh!


Great forum by the way. Now if only one of these existed for that troublesome MS Word....

 

[Mark O'Brien]

We have a resident Word expert. Dreamboat. You might want to check out her (and oz's) website.

http://www.thewordexpert.com

I believe that they have some tips and tricks there.