Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro warning window
-turn off macro warning window when all macros are deleted- bodyshopman |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro warning window
When all macros are truely gone the window will not show up any more. Check
that all of the modules have been deleted and that there is no code in any of the worksheets or ThisWorkbook. -- HTH... Jim Thomlinson "Bodyshopman" wrote: -turn off macro warning window when all macros are deleted- bodyshopman |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro warning window
I've got the same problem.
I've delete every macro and line of VB code I can find in all 12 sheets in the workbook. I save the workbook and close it. When I re-open the workbook, I get prompted to enable macros again. What could be causing it/where could there still be macros I've missed? Quintin "Jim Thomlinson" wrote: When all macros are truely gone the window will not show up any more. Check that all of the modules have been deleted and that there is no code in any of the worksheets or ThisWorkbook. -- HTH... Jim Thomlinson "Bodyshopman" wrote: -turn off macro warning window when all macros are deleted- bodyshopman |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro warning window
Debra Dalgleish shows how to clean up all the remnants of macros:
http://www.contextures.com/xlfaqMac.html#NoMacros Quintin wrote: I've got the same problem. I've delete every macro and line of VB code I can find in all 12 sheets in the workbook. I save the workbook and close it. When I re-open the workbook, I get prompted to enable macros again. What could be causing it/where could there still be macros I've missed? Quintin "Jim Thomlinson" wrote: When all macros are truely gone the window will not show up any more. Check that all of the modules have been deleted and that there is no code in any of the worksheets or ThisWorkbook. -- HTH... Jim Thomlinson "Bodyshopman" wrote: -turn off macro warning window when all macros are deleted- bodyshopman -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro warning window
Thanks. That fixed it :-)
"Dave Peterson" wrote: Debra Dalgleish shows how to clean up all the remnants of macros: http://www.contextures.com/xlfaqMac.html#NoMacros Quintin wrote: I've got the same problem. I've delete every macro and line of VB code I can find in all 12 sheets in the workbook. I save the workbook and close it. When I re-open the workbook, I get prompted to enable macros again. What could be causing it/where could there still be macros I've missed? Quintin "Jim Thomlinson" wrote: When all macros are truely gone the window will not show up any more. Check that all of the modules have been deleted and that there is no code in any of the worksheets or ThisWorkbook. -- HTH... Jim Thomlinson "Bodyshopman" wrote: -turn off macro warning window when all macros are deleted- bodyshopman -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a warning window | Excel Discussion (Misc queries) | |||
Creating a Warning window | Excel Worksheet Functions | |||
Macro Warning | New Users to Excel | |||
macro warning | New Users to Excel | |||
Macro warning window | Excel Discussion (Misc queries) |