Excel-VBA : Prevent Changing the WorkSheet Name

Many a times you need a scenario where you don't want user to change the worksheet name in you Excel work book.

Its quite easy to do.

Steps:

Select WorkSheet

Select WorkSheet from dropdown

Select SelectionChange

Now you will see the function Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Add the following code in the function.

If Sheet9.Name <> "FixedName" Then

   Sheet9.Name = "FixedName"

End If

Code

And thats it you are done. Lets test our program.

Go to excel and try changing the worksheet name.

Prevent changing the sheet name