In addition to the empty module others have pointed out, you could have
inadvertantly added code in a worksheet module or code in Thisworkbook.

That also has to be deleted.

Other things could contribute, like Forms, Class Modules

See Debra's site for more on this.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros


Gord Dibben MS Excel MVP


On Mon, 14 Jan 2008 10:19:06 -0800, Lisa Neron
wrote:

I am using Excel 2003. I have been creating a multi-sheet workbook tmeplate
with lots of named cells and referencing cells between the various sheets. I
started with another spreadsheet template I had and revised it severely for
the new template. The original template did not have any macros and therefore
never gave a warning about macros when opening the template (my macro
security level is medium). The new template started out the same (ie., no
macro waning on opening), but now suddenly has started displaying the warning
message that the template contains macros with the options to disable or
enable the macros. If I look under Tools/Macro/Macros, no list of macros is
displayed, so there is nothing to delete.

Does anyone know why the macro warning is displaying even though I have no
macros in the template, and how can I stop the warning from displaying?

Thanks,
Lisa