Enable Macro Message but no macros involved

Posted by Mary Sue Darwent on February 16, 2001 1:06 PM

I have several spreadsheets (Excel 97- on NT & WIN95) for which I get the "enable" or "disable" macro message on opening. There are no macros and also no module sheets in these workbooks. I've also checked for named ranges--none found. These worksheets have been checked for viruses and the styles list is clean and normal.

Can anyone give me any other ideas as to what can cause these bogus macro messages?

Posted by Ivan Moala on February 16, 2001 4:54 PM

Right click or the sheet tabs & select View code.
If any code in the worksheet excell object modules
then delete these.......do this for every sheet.

Ivan

Posted by Dave Hawley on February 17, 2001 1:36 AM

Hi Mary Sue

This article may apply:

http://support.microsoft.com/support/kb/articles/Q199/9/72.ASP?LN=EN-US&SD=gn&FR=0&qry=Enable%20Macros%20open&rnk=10&src=DHCS_MSPSS_gn_SRCH&SPR=XLW

Dave

OzGrid Business Applications