Hello everyone. I am working on a template for my team, and I want the users to have the ability to change the names of the sheets without the ability to change the order they are in.

I have used "Protect Workbook", and it accomplishes half of what I want (locking the order of the sheets) but I still want users to have the ability to change the titles of the tabs. Any idea how to make this happen?

Cheers ahead of time! :D

You cannot change the titles of the tabs while the workbook is protected, so you'll have to do something like this:SUB F()

activeworkbook.unprotect("password?")
sheets(inputbox("Please enter the name of the sheet you want to change.")).name = _
inputbox("Enter the new name here.")
activeworkbook.protect("password?")

END SUBThat should get you started with the process you might want to think about.

Hello everyone. I am working on a template for my team, and I want the users to have the ability to change the names of the sheets without the ability to change the order they are in.

I have used "Protect Workbook", and it accomplishes half of what I want (locking the order of the sheets) but I still want users to have the ability to change the titles of the tabs. Any idea how to make this happen?

Cheers ahead of time! :D

if you wanted to get really wizzie, you could create a form that reads the current sheet names, and allows the user to enter a new name against a current name, hit a button and 'pow', unprotect sheet, change the name, reprotect the sheets..and display and congratulations message, red arrows flyin gpast...yeah ok..too much tea i know...5 cup inside of an hour....and no custard creams!!!!