Macro Warning Message

[Lisa Neron]

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

 

[JP]

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

 

[FSt1]

hi,
not sure but it may be that you have an empty module in the workbook.
to check open the vb editor(ALt+F11). on the left side, in the project
window, click to expand your project(file). if it has a module, it will be at
the bottom. right click the module and from the popup click remove module.
you will be prompted to save the contents of the module to a bas file. since
there is nothing in the module, click
no.

that should do it

regards
FSt1

 

[Gord Dibben]

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

 

[Lisa Neron]

Thanks FST1, JP and Gord,

Your answers solved my problem. I had started looking into using macros a
little while ago but decided to leave it until I had more time to learn them
in more detail. I guess my poking around left some VB code in my worksheets.
I've deleted it all and the message has disappeared.

Thanks,
Lisa

 

[JP]

Glad to hear it worked!

--JP