Sheet Hide and Rename

[CindyA]

Is there any way to disable the menu option of "Sheet, Unhide" and "Sheet, Rename" on just the one sheet you are working on?

Thanks in advance.

 

[Oaktree]

To prevent users from unhiding or renaming sheets at all, consider using tools --> protection --> protect workbook (structure)

For just one sheet, right click on the sheet tab and consider code such as:

Private Sub Worksheet_Activate()
ActiveWorkbook.Protect
End Sub

Private Sub Worksheet_Deactivate()
ActiveWorkbook.Unprotect
End Sub