Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |