Roger

You have to also delete the module the macro(s) were stored in.

With your workbook open hit Alt + F11 to open VBEditor then CTRL + r to open
Project Explorer.

Expand your workbook/project and right-click on Module1 and "Remove"

Click NO when asked if you want to Export the module.


Gord Dibben MS Excel MVP

On Fri, 22 Dec 2006 12:13:01 -0800, Roger
wrote:

I have a workbook that I used a few macros on, and possible created one in
(but deleted) and now whenever anyone opens it they get the enable/disable
macro warning. I've looked in all places that I know to find a macro to
delete, but there is nothing. How to I clear what ever is prompting the
warning

thanks in advance