Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Warning Message
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Warning Message
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Warning Message
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 "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Warning Message
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Warning Message
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 "Gord Dibben" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Warning Message
Glad to hear it worked!
--JP On Jan 14, 3:27*pm, Lisa Neron wrote: Thanks FST1,JPand *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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warning Message | Excel Worksheet Functions | |||
Warning Message | Excel Discussion (Misc queries) | |||
Warning Message | Excel Worksheet Functions | |||
Stoping the Macro Warning Message | Excel Discussion (Misc queries) | |||
How to I get a warning message box | Excel Worksheet Functions |