Sheet Hide and Rename

CindyA

Board Regular
Joined
May 1, 2002
Messages
102
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.
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,437
Members
410,610
Latest member
renatha prado
Top