protecting worksheet tab names

[Paul]

I have a worksheet that is Protected, but it seems that users are still able
to change the name of the worksheet by double clicking on the tab name. Is
there a way to prevent users from changing the tab name when the sheet is
protected?

Thanks in advance,

Paul

 

[JLGWhiz]

One way is to put code something like this in the Sheet code module.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If ActiveSheet.Name <> "Sheet1" Then
ActiveSheet.Name = "Sheet1"
End If
End Sub

 

[AltaEgo]

Protect your workbook in addition to any worksheets.

 

[Barb Reinhardt]

Have you considered using Worksheet codenames? Read here for more info.

http://www.cpearson.com/excel/codemods.htm

 

[Paul]

Good suggestions, everyone. You've given me a simple solution to my
problem, as well as additional information that I can investigate further.

My thanks to JLGWhiz, AltaEgo and Barb Reinhardt.

Paul