1. Open the offending template
2. Alt-F11 to open the VB Editor
3. Ctrl-R to open the Project Explorer (if not already open)
4. Double-Click on "VBAProject (templatename)" and look for "Modules"
5. Double-Click on "Modules" and you should see an empty module there
6. Delete it, save and close.



HTH,
JP

On Jan 14, 1:19*pm, 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