You were clear, maybe I wasn't. I don't know the name of the popup you
need. So run my macro to get the names of all of them and start
experimenting to find it.

--
Jim
"Gordon" wrote in message
...
| 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
|
|