PDA

View Full Version : excel 2007 cell context menu question



tx7399
08-02-2012, 08:04 AM
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
08-02-2012, 10:10 AM
With Application.CommandBars("Cell")

.Controls("Sort").Enabled = False
'etc.
End With

tx7399
08-02-2012, 11:11 AM
Thanks xld,

Works great!