how to remove all macros

[aberdonian user]

i am opening the file that "has" macros, so excel asks i want to enable,
disable, etc, but i cannot see it on the list of macros (Tools -> Macro ->
Macros..., or Alt-F8). it is blank... how should i check/delete the macros
that are hidden somehow so i dont' get this annoying message?

thank you in advance.

regards,
jim

 

[Dave Peterson]

Check out Debra Dalgleish's site:
http://contextures.com/xlfaqMac.html#NoMacros

 

[Gary''s Student]

You will get this message if you have empty modules that may have contained
macros in the past.

1. Open the VBE (ALT-F11)
2. delete all modules
3. for each worksheet, right-click the tab name and select View Code.
Delete any worksheeet macros.
4. also delete any workbook macros.