Is it possible to block or hide some right-click functions on the Sheet Tab
bar? I do not want the User to have the "Unhide" capability for example.

Thanks for your help.

Rick

Hi,
Protect the sheet

"rick" wrote:

Is it possible to block or hide some right-click functions on the Sheet Tab
bar? I do not want the User to have the "Unhide" capability for example.

Thanks for your help.

Rick

Rick

For reasons best know to Microsoft this is called the PLY commandBar and to
disable options use

Sub DeactivateIt()
'Command bars
With Application.CommandBars("Ply")
.Controls("Unhide...").Enabled = False
End With
End Sub

Note the very fussy syntax with 3 dots after the menu option. Any option you
disable must be EXACTLY as it apperars when you right click.

Don't forget to set it back to TRUE on workbook close.

Mike

"rick" wrote:

Is it possible to block or hide some right-click functions on the Sheet Tab
bar? I do not want the User to have the "Unhide" capability for example.

Thanks for your help.

Rick