View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default 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.