disable Edit/Cut menu option (and other specific ones)

  • Thread starter Thread starter cm
  • Start date Start date
C

cm

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
 
found answer in another post:

Application.CommandBars(1).Controls("Edit").Controls("Cut").Enabled = False
 
Back
Top