Custom Right Click Menu

[Mr Nick]

Having read previous posts on similar subjects, I can not find a satisfactory solution to my requirements.

I wish to almost entirely remove the right click menu apart from the Clear Contents option but have only come across ways to disable the menu completely.

Is it possible to use something similar to
Application.CommandBars("Right Click Menu").Controls _
("Options...").Enabled = False

Is this possible or am I going to have to rethink my strategy?
This message was edited by Mr Nick on 2002-04-03 07:06

 

[Dave Hawley]

Hi Mr Nick


Try right clicking on the Excel icon, top left next to "File" and selecting "View Code", now paste is this.

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

Application.CommandBars("Cell").Controls("Clear Co&ntents").Enabled = False

End Sub

_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

This message was edited by Dave Hawley on 2002-04-04 23:39

 

[Mr Nick]

Cheers Dave.

That one works like a dream!