Cannot disable Paste Button in Columns context menu

**KiwiRickToo** · 02-02-2016, 12:42 AM

Hi All

I'm using the following this code to try and hide the Paste button so that when the user accesses (right-mouse click) the context menu for the selected Column it is disabled

Please Login or Register  to view this content.

All my google searches have identified this controlID as 22 however the code does not work. It works for other controls I hide like Paste Special

Any ideas on this please. Using Excel 2010

Thanks in advance

Rick

**romperstomper** · 02-02-2016, 04:22 AM

Do you only want to disable it on the Column menu, or on all menus? You'll need to modify the CustomUI part of the workbook in order to do either.

**KiwiRickToo** · 02-02-2016, 05:52 PM

Both column and Row but not Cells. I've tried doing it with CustomUI but can't find correct idMso for PasteSpecial

**KiwiRickToo** · 02-03-2016, 02:19 AM

I would prefer to do this using CustomUI. Attached file has xml code to modify the context menu but I need to find the idMso to also disable the Paste Special, Insert and Delete options.

Any help appreciated

**romperstomper** · 02-03-2016, 04:23 AM

It look as though you need a combination of the XMl and the commandbars code to get all the controls. (you need ids 21437, 3183 and 294 for those controls).