Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't Disable the "Insert - Rows" menu option in Excel using VBA m
I have a macro for which I do some conditional checks in the SelectionChange
event for a worksheet. When one of my conditions evaluates to true I'm trying to do the following: *) Disable the Insert - Rows menu option (from the main menu bar at the top of Excel) I have tried many different things. The closest I can get is to disable the "Insert" control entirely (which is not acceptable). I only want to disable the "Insert Rows" option. The following code disables the entire "Insert" control on the Worksheet Menu Bar: Application.CommandBars("Worksheet Menu Bar").Controls("Insert").Enabled = False I CAN'T figure out how to disable the Rows option underneath the Insert control though!! Any help would be greatly appreciated. Thanks -- PK9 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
No "Excel Services" option in Publish menu | Excel Discussion (Misc queries) | |||
Stop users from accessing "Protection" option from "Tools" menu | Excel Programming | |||
How to disable the "Insert Copied Cells" context menu item | Excel Programming | |||
Excel "Work"menu option | Excel Programming |