LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 183
Default disable a menu control short key

hello,
I would like to disable the cut control (and its shortkey CtrlX).
I have managed to disable the control by greying the menu item with the
following code but the shortkey still work.
Any idea?
Thanks

Sub preventcut()
' disable cut
Application.CommandBars("Worksheet Menu Bar").Reset
With Application.CommandBars("Worksheet Menu Bar").Controls
.Item(2).Controls(3).Enabled = False
End With
End Sub
Sub resetmenu()
Application.CommandBars("Worksheet Menu Bar").Reset
End Sub



--
caroline
 
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
Disable the Delete Control in the Edit Menu Virtual Hillbilly Excel Programming 1 July 23rd 06 10:50 AM
disable built-in menu and short-cut key for cut command travis Excel Discussion (Misc queries) 1 July 21st 06 05:18 PM
Disable Control in Tools Menu Juan Sanchez[_3_] Excel Programming 4 September 30th 04 09:40 PM
pls help: short cut menu doesn't show when right click mouse Yong Wah Excel Programming 1 October 23rd 03 01:56 PM
short cut menu doesn't show when right click on mouse Yong Wah Excel Programming 2 October 21st 03 01:42 PM


All times are GMT +1. The time now is 10:31 AM.

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

About Us

"It's about Microsoft Excel"