Deleting Macros

[Glenn Bendle]

I had a document with no macro in it, which was fine. Then
I created a macro, but later deleted it. But now,
everytime I open the file it says that the workbook
contains macros - enable/disable......
There are no macros in the workbook, so how can I get rid
of the message at file open (without setting security
level to low)?

Thanks in advance.

Glenn

 

[Frank Kabel]

Hi Glenn
you also have to remove the (empty) module in your workbook:
- open the VBA editor (ALT+F11)
- delete/remove the empty modules
- close the editor, save your workbook and try again

 

[Glenn Bendle]

Thank you Frank,

Works like a treat! Just for other people with this
problem, when you go into VBA, make sure you're in design
mode, or you will be unable to remove the modules.

Regards,

Glenn

 

[David]

Glenn Bendle wrote

Works like a treat! Just for other people with this
problem, when you go into VBA, make sure you're in design
mode, or you will be unable to remove the modules

Hmm... I don't know what version of XL you are running, but I have always
been able to remove modules under 2000, design mode or not.