Removing Items from Right Click Menu

[bigstickmuffin]

I am making a custom program in Excel and want to remove all but the Copy and Paste Values commands from the right click menu. I have it now so that if I right click on a cell those are the only things in the menu. But if I copy something, a Paste Special button gets added to the menu. I want to remove that using VBA.

Thanks

 

[xenou]

There is more than one (two at least) "Cell" menus. You must deal with them all.

I usually do this in a loop:

Pseudocode:

For Each command bar
    If command bar name is "Cell"
        Change menu items
    End If
Next

Does that make sense? It is instructive to do a loop just to get all the command bar names ... its a surprise to see the same bar in the list more than once!

HTH,
ξ

(applies to XL2003)