Disable protection menu item

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
application.CommandBars(1).Controls("Tools").Controls("Protection").enabled=
false


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks Bob. Do you know if there are any built-in shortcut keys to access
this 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)
 
Great. Thanks again!

Bob Phillips said:
I on ly know Alt-T-P which won't work when disabled.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top