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 Removed),
Gord Dibben <gorddibbATshawDOTca> Proclaimed from the tallest tower:
> 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
>
> On Wed, 7 Mar 2007 16:40:32 -0000, "ChrisM"
> <(E-Mail Removed)> wrote:
>
>> 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!
--
Regards,
Chris.
(Remove Elvis's shoes to email me)
Similar Threads
