Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protection
Hi
Lotus 123 had a protection choice that allowed macro execution. Is there a setting or VBA code equivalent in Excel or is it necessary to toggle the protection setting in the procedure. Thanks TK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protection
the userinterfaceonly argument to the protection method (for worksheets)
allows macro execution. It can only be set with code and is non-persistent in that if you close and reopen the workbook, the setting always defaults to False. In xl2002 and later, you have to supply the password to change this setting. In earlier versions, you were not required to. -- Regards, Tom Ogilvy "TK" wrote in message ... Hi Lotus 123 had a protection choice that allowed macro execution. Is there a setting or VBA code equivalent in Excel or is it necessary to toggle the protection setting in the procedure. Thanks TK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
protection
Macro control is primarily done at the application
level. goto Tools..Macro..Security to see the options. HTH -----Original Message----- Hi Lotus 123 had a protection choice that allowed macro execution. Is there a setting or VBA code equivalent in Excel or is it necessary to toggle the protection setting in the procedure. Thanks TK . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) |