Deleting a Macro you can't find.

[Phillip Hauenstein]

I created a Macro to help myself format a set of cells in
many different workbooks faster. Now that I'm done using
the macro and thought I deleted it, I'm still being
prompted to enable or disable the macro when I can't even
find it in the tools/macros area. Please let me know what
I can do to rid myself this mess without disabling the
macro virus checker.

 

[Ken Wright]

You could well have event macros in the sheet modules. Go into the VBE again, and double click on
each sheet in the list that you see, ie the Sheet1 / Sheet2 / Sheet3 / ThisWorkbook bits below

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook

If you see any code in the white window on the right, then just delete it, AS LONG, as you are
sure you don't need it.

Then just close the VBE, save the file and you should be done. If you still have problems, then
by all means mail me one of the books if you can (By all means delete all the content), and I'll
take a look. You need to take the NOSPAM out of my email address.