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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide sheet 2
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
password protect individual sheets 1
Hide, unhide macro 19
Toggling xlVeryHidden 8
Open Specific Worksheet Using Button Form Control in Excel 0
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Hide a Sheet Q 4

Back
Top