Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Context Menu (Sub-Menu Disable/Enable)
By right clicking on a cell I get a context menu where I can choose Insert...
or Delete... Each of these choices produces a sub-menu: Shift cells right, Shift cells left, Insert Entire Row, Insert Entire Column. The Delete option has the same sub-menu except it is for the delete option. I know how to disable or make invisible an option: Application.CommandBars("cell").Controls("Insert.. .").Visible = False Application.CommandBars("cell").Controls("Insert.. .").Enable = False My question is how do I disable or make invisible only a sub-menu item such as "Insert Entire Row"? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Sub-Menu of a Context Menu | Excel Programming | |||
Context menu | Excel Programming | |||
How to disable the "Insert Copied Cells" context menu item | Excel Programming | |||
Enable/Disable Menu Items | Excel Programming | |||
Menu Items and Disable/Enable in Excel 2003 | Excel Programming |