Finding/deleting macros...

J

johnnyrad

Thanks to anyone who helped me with my finding/deleting link
question...

Now in a different workbook.. when i open it, it prompts whether t
enable or disable macros. When i go to the macros list though, it
blank, none listed. How could I find where thesee phantom macros ar
and get rid of them? FYI we always choose Disable macros. This is
work book that was built a long time ago, probably has about 50+ tab
of which we only currently use about 15.

Thanks for any help!
Chri
 
F

Frank Kabel

Hi
you also have to remove the modules:
- open the VBA editor (hit ALT+F11)
- select the modules and delete/remove them (even if they are empty)
- also check the worksheet modules and the workbook module and remove
all code from them
- close the vBA editor and save your workbook

Now try again
 
Top