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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ChrisM - 07 Mar 2007 16:40 GMT

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!

Signature

Regards,
Chris.
(Remove Elvis's shoes to email me)

Reply to this Message

Gord Dibben - 07 Mar 2007 17:06 GMT

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

> Hi,
>
[quoted text clipped - 14 lines]
>
>Thanks!

Reply to this Message

ChrisM - 07 Mar 2007 17:40 GMT

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.

> After deleting the macro you created you must also delete the empty
> Module that housed it.
[quoted text clipped - 30 lines]
>>
>> Thanks!

Signature

Regards,
Chris.
(Remove Elvis's shoes to email me)

Reply to this Message