Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable protection menu item
1) Is there a way to programmatically disable the "protection" choice on the
"Tools" menu? If so, how? 2) Also, is there a shortcut key that should also be trapped, and if so, how is that done? 3) Any other commonly used methods for accessing this option? Note: This doesn't need to be an absolutely perfect catch-all since it is really designed to discourage users not supply absolute security. Thanks much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable protection menu item
application.CommandBars(1).Controls("Tools").Contr ols("Protection").enabled=
false -- HTH RP (remove nothere from the email address if mailing direct) "quartz" wrote in message ... 1) Is there a way to programmatically disable the "protection" choice on the "Tools" menu? If so, how? 2) Also, is there a shortcut key that should also be trapped, and if so, how is that done? 3) Any other commonly used methods for accessing this option? Note: This doesn't need to be an absolutely perfect catch-all since it is really designed to discourage users not supply absolute security. Thanks much in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable protection menu item
Thanks Bob. Do you know if there are any built-in shortcut keys to access
this menu item? "Bob Phillips" wrote: application.CommandBars(1).Controls("Tools").Contr ols("Protection").enabled= false -- HTH RP (remove nothere from the email address if mailing direct) "quartz" wrote in message ... 1) Is there a way to programmatically disable the "protection" choice on the "Tools" menu? If so, how? 2) Also, is there a shortcut key that should also be trapped, and if so, how is that done? 3) Any other commonly used methods for accessing this option? Note: This doesn't need to be an absolutely perfect catch-all since it is really designed to discourage users not supply absolute security. Thanks much in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable protection menu item
I on ly know Alt-T-P which won't work when disabled.
-- HTH RP (remove nothere from the email address if mailing direct) "quartz" wrote in message ... Thanks Bob. Do you know if there are any built-in shortcut keys to access this menu item? "Bob Phillips" wrote: application.CommandBars(1).Controls("Tools").Contr ols("Protection").enabled= false -- HTH RP (remove nothere from the email address if mailing direct) "quartz" wrote in message ... 1) Is there a way to programmatically disable the "protection" choice on the "Tools" menu? If so, how? 2) Also, is there a shortcut key that should also be trapped, and if so, how is that done? 3) Any other commonly used methods for accessing this option? Note: This doesn't need to be an absolutely perfect catch-all since it is really designed to discourage users not supply absolute security. Thanks much in advance. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable protection menu item
Great. Thanks again!
"Bob Phillips" wrote: I on ly know Alt-T-P which won't work when disabled. -- HTH RP (remove nothere from the email address if mailing direct) "quartz" wrote in message ... Thanks Bob. Do you know if there are any built-in shortcut keys to access this menu item? "Bob Phillips" wrote: application.CommandBars(1).Controls("Tools").Contr ols("Protection").enabled= false -- HTH RP (remove nothere from the email address if mailing direct) "quartz" wrote in message ... 1) Is there a way to programmatically disable the "protection" choice on the "Tools" menu? If so, how? 2) Also, is there a shortcut key that should also be trapped, and if so, how is that done? 3) Any other commonly used methods for accessing this option? Note: This doesn't need to be an absolutely perfect catch-all since it is really designed to discourage users not supply absolute security. Thanks much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to disable the "Insert Copied Cells" context menu item | Excel Programming | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
Disable Menu Item | Excel Programming | |||
Disable File-Save menu item in macro? | Excel Programming |