how to remove all macros

  • Thread starter aberdonian user
  • Start date
A

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
 
G

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.
 
Top