Have use 'ply' for right clicks everywhere else!

"Ply" is the name of the worksheet tab popup (only).

To disable a popup you have to know its name (or disable all of them). This
is how you get a list:

Sub ListAllPopups()
Dim Counter As Integer
Dim CB As CommandBar
For Each CB In CommandBars
If CB.Type = msoBarTypePopup Then
Counter = Counter + 1
Cells(Counter, 1).Value = CB.Name
End If
Next
End Sub

--
Jim
"Gordon" wrote in message
...
| Any code disable right clicking on objects. Have use 'ply' for right
clicks
| everywhere else!
|
| Cheers
|
| G