Macro warning still on

[Jeremy]

I have Office 2003 - I put a macro in a table then
removed it from the Macro drop down. It has definitely
been removed as no macros appear in the box. However each
time I open the sheet it comes up with a warning to
remove or enable macros - but I dont have one in there?
Please help as I use the sheet a lot and it is annoying.

Thanks in advance.

 

[Debra Dalgleish]

When you record a macro, Excel creates a module in which the code is
stored. When you delete the macro, the module is not automatically
deleted. There are instructions for finding and removing code on the
following page:

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

 

[Peo Sjoblom]

You have to delete the module it was in as well, open the workbook, press
Alt + F11,
in the left project pane you should see your workbook, it has a tree
structure and one
folder is named modules, open it (double click), now yours is most likely
named Module1,
right click it and select Remove Module1 and when prompted to export answer
no.
Press Alt + Q to close the VBE and save the workbook.
It doesn't sound as you would have anything in thisworkbook or in any sheet
--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)