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.
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.
[VBA]With Application.CommandBars("Cell")
.Controls("Sort").Enabled = False
'etc.
End With
[/VBA]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks xld,
Works great!