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:

• Go to VBA Editor
• Expand your VBA Project
• Select the any Sheet
  

• Now select the "WorkSheet" from the first drop down on the right

• Select the SelectionChange from the second drop down on the right

• 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

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

Go to excel and try changing the worksheet name.

Also Read:

1. VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet
2. VBA-Excel: Create or Add Worksheets at the Run time.
3. How to Enable Macro in Excel
4. VBA-Excel: Get all the WeekDays or Working days in Specified Date Range, (excluding Satudays and Sundays)
5. VBA-Excel — AttachmentFetcher — Download all the Attachments from All the Mails of Specific Subject in Microsoft Outlook .