Mysterious macro(s)....

shanefowlkes · Apr 12th, 2002, 08:17 AM

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 · Apr 12th, 2002, 08:26 AM

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 · Apr 12th, 2002, 08:33 AM

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 · Apr 12th, 2002, 09:00 AM

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.

Apr 12th, 2002, 08:26 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 12th, 2002, 09:00 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 08:17 AM	#1
shanefowlkes New Member Join Date: Apr 2002 Posts: 16	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)

Apr 12th, 2002, 08:33 AM	#3
shanefowlkes New Member Join Date: Apr 2002 Posts: 16	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....