If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|