how to remove all macros

  • Thread starter Thread starter aberdonian user
  • Start date 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
 
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.
 
Back
Top