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

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
 
C

cm

found answer in another post:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top