Hi,
is it possible to customise the right click menu, ie add or move items?
Darren
Hi,
is it possible to customise the right click menu, ie add or move items?
Darren
Public Sub addCellMenu()
removeCellMenu 'just in case
With Application.CommandBars("Cell")
.Controls.Add(Type:=msoControlButton).Caption = "Routine1"
.Controls.Add(Type:=msoControlButton).Caption = "Routine2"
.Controls("Routine1").BeginGroup = True
.Controls("Routine1").OnAction = "Another"
.Controls("Routine2").OnAction = "YetMore"
End With
End Sub
Public Sub removeCellMenu()
On Error Resume Next
With Application.CommandBars("Cell")
.Controls("Routine1").Delete
.Controls("Routine2").Delete
End With
On Error GoTo 0
End Sub
--
HTH
Bob Phillips
"Darren" <darrenb.1@ntlworld.com> wrote in message
news:OC4NZJmSFHA.3372@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> is it possible to customise the right click menu, ie add or move items?
>
> Darren
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks