Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 441
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.programming
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.




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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.






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 441
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to disable the "Insert Copied Cells" context menu item Coen Excel Programming 21 February 9th 05 09:37 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM
Adding a menu item right click menu when clicking on a single. Andoni[_28_] Excel Programming 0 September 2nd 04 10:23 PM
Disable Menu Item OCI Excel Programming 0 May 19th 04 05:41 PM
Disable File-Save menu item in macro? BrianG[_4_] Excel Programming 1 February 25th 04 06:48 PM


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"