Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Edit/Cut menu option (and other specific ones)
found answer in another post:
Application.CommandBars(1).Controls("Edit").Contro ls("Cut").Enabled = False "cm" wrote: I want to disable specific menu options upon workwheet open. (I have not done this before). One need is to disable Edit/Cut, Edit/Copy, but NOT Edit/Paste. Other posts say to use the following example: Application.CommandBars("Worksheet Menu Bar").FindControl _ (ID:=522, Recursive:=True).Enabled = False 1. How do I find the correct 'ID' for each menu item I want to disable? 2. Does this section of code belong in the 'This Workbook' module? thanks, cm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable formula Bar in Option Menu | Excel Programming | |||
copy command is disable under edit menu | Excel Discussion (Misc queries) | |||
Disable the Delete Control in the Edit Menu | Excel Programming | |||
disable customize option when right click on menu bar | Excel Discussion (Misc queries) | |||
Disable Option from tools in Menu bar | Excel Programming |