Hi...

Right click has been disabled over the workbook but objects (Pictures, Word
Art) can still be selected. Sorry I wasn't clearer!

G

"Jim Rech" wrote:

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