Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I had an old macro in my spreadsheet that I deleted. However, whenever I
open the spreadsheet, I still get the warning saying the spreadsheet contains macros. When I look at the macros in the spreadsheet, there are none. Is there a way to stop that warning without adjsuting my security level? |
#2
![]() |
|||
|
|||
![]()
delete the module it was in also.
"Todd" wrote: I had an old macro in my spreadsheet that I deleted. However, whenever I open the spreadsheet, I still get the warning saying the spreadsheet contains macros. When I look at the macros in the spreadsheet, there are none. Is there a way to stop that warning without adjsuting my security level? |
#3
![]() |
|||
|
|||
![]()
This happens because the module that held the now-deleted code still
exists. Delete the module to avoid the warning. |
#4
![]() |
|||
|
|||
![]()
Debra Dalgleish has nice instructions for getting rid of macros at:
http://www.contextures.com/xlfaqMac.html#NoMacros Todd wrote: I had an old macro in my spreadsheet that I deleted. However, whenever I open the spreadsheet, I still get the warning saying the spreadsheet contains macros. When I look at the macros in the spreadsheet, there are none. Is there a way to stop that warning without adjsuting my security level? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleting a macro resulted in a problem | Excel Discussion (Misc queries) | |||
deleting a macro resulted in a problem | Excel Discussion (Misc queries) | |||
Macro warning (upon opening) | Excel Discussion (Misc queries) | |||
disable macro warning | Excel Discussion (Misc queries) | |||
After deleting a macro, I still get the pop-up when opening file | Excel Worksheet Functions |