'Contains Macros' When it doesn't...

[ChrisM]

Hi,

I have a very simple spreadsheet. The only 'advanced' feature it has is a
small lookup table that is an external data reference to an Access Database
Table. This external reference is set to auto-update on sheet open.

Problem is, as part of a failed experiment, I created a macro, then a while
later deleted it again, however, even though the sheet now contains no
macros(according to Tools->Macro), everytime I open it I get the message
'This contains macros, Enable Macros/Disable Macros/More Info

Is this because of the auto-update on the external reference, or do I have
some sort of 'zombie' macro hidden somewhere that is triggering this
message?

Please help...

Thanks!

 

[Gord Dibben]

After deleting the macro you created you must also delete the empty Module that
housed it.

Alt + F11 to open VBEditor, CTRL + r to open Project Explorer.

Click on your workbook/project and expand.

Right-click on Module1 or whatever name is given and Remove. Click No to "do
you want to export?"

Save the workbook.


Gord Dibben MS Excel MVP

 

[ChrisM]

Thank you, that worked perfectly.

Shame it doesn't automatically delete the empty module for you, or at least
give the option when it becomes empty...

Thanks again,

Chris.

In message (e-mail address removed),