excel 2007 cell context menu question

[tx7399]

Hi everyone,

In excel 2007, is it possible to edit with vba the right click context menu for cells? I would like to keep enabled: cut, copy, paste, and clear contents
but disable all other choices.

Thanks for your help.

[Bob Phillips]

[VBA]With Application.CommandBars("Cell")

.Controls("Sort").Enabled = False
'etc.
End With
[/VBA]

[tx7399]

Thanks xld,

Works great!