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. |
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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 08:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com