deleted macros but still getting enable macro message

[Elizabeth Gibson]

I deleted all the macros I had created in my worksheet
but I'm still getting the message telling me--this
worksheet contains macros asking me to enable/disable.

What else should I do to get rid of this annoying
message? Thanks!

 

[Andy B]

Hi

Try deleting the modules that held the macros. That should sort it for you.

 

[Ken Wright]

You need to delete any empty modules that housed those macros.

Hit ALT+F11 and this will open the VBE (Visual Basic Editor)
Top left you will hopefully see an explorer style pane. Within this pane you
need to search for
your workbook's name, and when you find it you may need to click on the + to
expand it. Within
that you should see the following:-

VBAProject(Your_Filename)
Microsoft Excel Objects
Sheet1(Sheet1)
Sheet2(Sheet2)
Sheet3(Sheet3)
ThisWorkbook
Modules
Module1
Module2
etc etc (You may have just 1 of these)

If you have named your sheets then those names will appear in the brackets above
as opposed to
what you see at the moment in my note.

Right click on the modules and select remove. When prompted with a question re
exporting, just
hit no. Then hit File / Close and return to Microsoft Excel and save the file.

 

[Dave R.]

The macros are contained in MODULES you can see in the explorer on the left
side of the screen. Select any/all MODULES listed there and REMOVE them.

 

[Frank Kabel]

Hi
there're probably some empty modules in your workbook. Try the
following:
- open the VBA editor
- delete/remove all (empty) modules
- check the worksheet modules and the workbook module
- cloese the VBA editor and save your workbook
- try again

 

[jgorow]

I to have a problem with deleting a macro. I did as suggested here.
Went to Visual Basic Editor, went to Project Explorer and removed th
module. However, whenever I open the workbook, it stills asks if
want to enable the macro.

What am I doing wrong?

Joh

 

[Frank Kabel]

Hi
then also check the worksheet modules and the workbook module

 

[Dave Peterson]

Debra Dalgleish has some pretty pictures showing this stuff at:

http://www.contextures.com/xlfaqMac.html#NoMacros