Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
Protecting worksheet | Excel Worksheet Functions | |||
Protecting Range Names | Excel Discussion (Misc queries) | |||
protecting the worksheet | Excel Worksheet Functions | |||
Protecting Worksheet | Excel Discussion (Misc queries) |