ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable protection menu item (https://www.excelbanter.com/excel-programming/324295-disable-protection-menu-item.html)

quartz[_2_]

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.

Bob Phillips[_6_]

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.




quartz[_2_]

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.





Bob Phillips[_6_]

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.







quartz[_2_]

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