Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to disable the "cut" control in the "edit" menu in the Command
Bar, as well as in any other menu where "cut" may appear. So far the below code, which I input into the specific sheet's code window, works, but it does not disable the key board shortcut "control x". That is but a minor problem. The main issue is that the code disables the "cut" control in all of my Excel files. Any ideas on how I could disable the keyboard short cut as well make the code apply only to a particular sheet rather than to my Excel in general? Any help is greatly appreciated. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Ctrl As Office.CommandBarControl For Each Ctrl In Application.CommandBars.FindControls(ID:=21) Ctrl.Enabled = False Next Ctrl End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable Command Bar Edit Control | Excel Programming | |||
Disable control | Excel Programming | |||
disable control | Excel Programming | |||
disable control | Excel Programming | |||
Disable Control s | Excel Programming |