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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to record a macro within a macro 9
Still getting Macro Security Warning Message after removing Macro 3
How to stop warning about non-existent macros? 3
How to see list or names of the macros in a spreadsheet 1
Remove macro warning 1
Macro Names display 1
No macro's but still macro warning 2
Checking how a macro is called 3

Back
Top