Enable Macro Won't Go Away

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I deleted the empty VBA module according to the
instructions how to solve this problem, and my Excel 2002
spreadsheet shows no Macros but I STILL get the
enable/disable macros at the opening of the spreadsheet.

When using alt-F11, there are no modules so I'm open for
suggestions?
 
Don,

Have you checked ThisWorkbook and the worksheet modules.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Don, could be some code in a sheet module, have a look here for details
http://www.contextures.com/xlfaqMac.html#NoMacros
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
-----Original Message-----
Don, could be some code in a sheet module, have a look here for details
http://www.contextures.com/xlfaqMac.html#NoMacros
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **




.
Thank you - the trick was deleting some code in the
Click to expand...
Sheet1 object. Thanks again!
 
Back
Top