View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Control of Sheet Tab functions?

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