Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable macro
Is there anyway that the running of macros can be disabled while EXCEL is
OPEN. The only way that I have found to disable macros is to shut down EXCEL, restart EXCEL, and select to disable the macros. RICK |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable macro
You can disable code that run when you open the workbook by holding the
Shift key when you open the workbook in Excel. Note: You can use the macro's only the code that run automatic when you open the workbook will not run -- Regards Ron De Bruin http://www.rondebruin.nl "RICK" wrote in message ... Is there anyway that the running of macros can be disabled while EXCEL is OPEN. The only way that I have found to disable macros is to shut down EXCEL, restart EXCEL, and select to disable the macros. RICK |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable macro
once disabled can it be re-enabled without closing down and re-opening the
workbook? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable macro
You can write all your macros so that they will conditionally operate or not
depending on a certain value in a certain cell.........kinda like a password, only certain folks know what the password is, and where it is supposed to go.......... hth Vaya con Dios, Chuck, CABGx3 "RICK" wrote: Is there anyway that the running of macros can be disabled while EXCEL is OPEN. The only way that I have found to disable macros is to shut down EXCEL, restart EXCEL, and select to disable the macros. RICK |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable/disable macro
I think you have to close and reopen any workbook to enable/disable macros for
that workbook. RICK wrote: once disabled can it be re-enabled without closing down and re-opening the workbook? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |