MrExcel Publishing
Your One Stop for Excel Tips & Solutions

macro warning when opening a sheet


Posted by Rohan on October 12, 2001 2:35 PM

HOw do I get rid of this warning if I have deleted all macros in the ss?

Used to have a macro--no longer do--but can't seem to get the warning message to go away on opening of the sheet.

Thanks.


Posted by DAS on October 12, 2001 3:07 PM


See "Macro warning message won't go away " post below.

Posted by Rohan on October 12, 2001 4:55 PM

:: Deleted the module--saved--recreated the module empty--saved--still seeing hte message--under Tools->Macros there are NO macros listed--any other hints?

Posted by Damon Ostrander on October 14, 2001 10:56 PM

Hi Rohan,

There are lots of places in a workbook that macros can reside other than in a macro module. You will get the macro warning message if any VBA code exists anywhere in your workbook. You need to look in each worksheet's event code area, the workbook's event code area, and also make sure there are no userforms or class modules as these always involve VBA code. When you look at macros using Tools -> Macro you will only see macros that are public Sub macros. You will not see private macros, and you will not see Functions or other types of code (for example, declaration statements). As an example, any commandbutton you create will automatically create a private click event handler that is a macro that will not show up using Tools -> Macro.

I hope this helps.

Damon :: Deleted the module--saved--recreated the module empty--saved--still seeing hte message--under Tools->Macros there are NO macros listed--any other hints?