can't find my macro...

[victoreae]

Using Excel 2002

I had been experimenting with making a macro that would copy and paste
values before closing.

I decided that I would not need it after all and thought I had deleted
it using the tools; Macro; macros window. Actually I can no longer see
it or any macros in that window.

Now, when I open my spreadsheet it still gives me the disable macros
dialog.

Where else do I need to look to delete whatever is still left of this
macro so that the macro dialog no longer pops up when the spreadsheet
is opened?

Thank you!

 

[Don Guillett]

Remove the module that it was in

 

[Debra Dalgleish]

When you record a macro, Excel creates a module in which the macro is
stored. There are some instructions here for finding and removing
modules, or other traces of code:

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