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
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