Control of Sheet Tab functions?

  • Thread starter Thread starter rick
  • Start date Start date
R

rick

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
 
Back
Top