Disabling sheet rename

[orit]

How can I disable changing the name of the sheets?

Thanks

 

[DominicB]

Good morning orit

Tools > Protection > Protect Workbook should do the trick.

HTH

DominicB

 

[SydneyGeek]

Tools > Protection > Protect Workbook.

Enable the options to protect the structure, then set a password.
Users will be unable to change sheet names, insert or remove them, without first entering the password.

Denis

 

[orit]

Thanks a lot

Is there a way to disable renaming specific sheets only using vba?

Thanks

 

[SydneyGeek]

You can also disable sheet renaming by protecting each sheet that you want left alone. This also locks cells, but the following code will lock only cells with formulas and leave others free for data entry.
To use, do the following:
1. Press Alt+F11 to go to the macro editor
2. Insert > Module and paste the following code
3. Close the VBA editor and return to Excel
4. Select a sheet, press Alt+F8 and double-click Protect Sheet

5. To unlock a sheet, press Alt+F8 and double-click Unprotect sheet instead.

Option Explicit

Sub ProtectSheet()
Cells.Select
With Selection
    .Locked = False
    .SpecialCells(xlCellTypeFormulas, 23).Select
    .Locked = True
End With
Range("A1").Select
ActiveSheet.Protect "password"
End Sub

Sub UnprotectSheet()
ActiveSheet.Unprotect "password"
End Sub

If you want to use a different password, change it in the code -- but make sure that the sheet is unlocked first, and the passwords match in both subroutines.

Denis

 

[orit]

Thanks a lot