PROTECT SHEET NAME

[Ash Koparkar]

​using vba code How to prevent sheet tab names means user can't change sheet name ?

[Jan Karel Pieterse]

Protect the workbook (Review tab).

[Logit]

.
If you don't have a large number of sheets to protect you can place this macro into each SHEET MODULE. Obviously you will
need to change the sheet name in the macro to match the SHEET MODULE the macro is being pasted in.

Private Sub worksheet_SelectionChange(ByVal Target As Excel.Range)


If ActiveSheet.Name <> "Master" Then   '<--- edit sheet name to match existing name
ActiveSheet.Name = "Master"   '<--- edit sheet name to match existing name
End If
End Sub

[Paul_Hossler]

​using vba code How to prevent sheet tab names means user can't change sheet name ?

If you're worried that users will change the name on the tab of a worksheet and that might cause a macro to break:

Worksheets ("Stores") subscript error because some user changed the name to Worksheets("Dept")

I'd change the code name that the user doesn't see to something and use that in my macros.

Then it doesn't matter is the user changes the name. You can always get it by using "Data.Name" in my example


Capture.JPG

[Ash Koparkar]

.
If you don't have a large number of sheets to protect you can place this macro into each SHEET MODULE. Obviously you will
need to change the sheet name in the macro to match the SHEET MODULE the macro is being pasted in.

Private Sub worksheet_SelectionChange(ByVal Target As Excel.Range)


If ActiveSheet.Name <> "Master" Then   '<--- edit sheet name to match existing name
ActiveSheet.Name = "Master"   '<--- edit sheet name to match existing name
End If
End Sub

[Ash Koparkar]

[Logit]

.
Did you paste it into the Sheet Level Module ?

[Ash Koparkar]

.
Did you paste it into the Sheet Level Module ?

[Logit]

See attached.