protecting worksheet tab names
 

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

protecting worksheet tab names
 

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




"Paul" wrote in message
...
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

protecting worksheet tab names
 

Protect your workbook in addition to any worksheets.
--
Steve

"Paul" wrote in message
...
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

protecting worksheet tab names
 

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

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


"Paul" wrote:

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

protecting worksheet tab names
 

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