Disable cut, copy, paste menu items for Excel 2013

Asked Mar 26 '15 at 13:12

Active Jul 28 '16 at 18:23

Viewed 1,927 times

I would like to disable the cut, copy, paste menu items form the header menu of Excel 2013.

I think that the solution suggested here works for Excel 2000, 2003 and 2007, but not for Excel 2013 because my cut, copy, paste menu items are still enabled.

enter image description here

The part of the code that isn't working is:

'Activate/deactivate cut, copy, paste and pastespecial menu items
Call EnableMenuItem(21, Allow) ' cut
Call EnableMenuItem(19, Allow) ' copy
Call EnableMenuItem(22, Allow) ' paste
Call EnableMenuItem(755, Allow) ' pastespecial

edited Jul 09 '18 at 18:41

Community

asked Mar 26 '15 at 13:12

Bronzato

9,438
29
120
212

What part doesn't work? – brettdj Mar 26 '15 at 13:16
I updated my question to explain what is not working. – Bronzato Mar 26 '15 at 13:20
Did you put a msgbox or something to make sure it runs this code – phil652 Mar 26 '15 at 17:04
Yes I set a breakpoint. – Bronzato Mar 26 '15 at 17:10
1

If you cannot disable them, how about reversing them? Basically, I am proposing to catch the event and immediately issue an UNDO command. http://www.jkp-ads.com/Articles/CatchPaste.asp http://stackoverflow.com/questions/7004754/how-to-programmatically-code-an-undo-function-in-excel-vba – Ralph Mar 27 '15 at 09:23

Disable cut, copy, paste menu items for Excel 2013

0 Answers0