Hi I want to automate my tabname (sheet3) based on cell c53.
A member called Bigwheel advised this



"Private Sub Worksheet_Activate()
Sheets(1).Name = Range("H2").Value
End Sub

Enter the code above on the required worksheet i.e. double click the sheet in the VB editor which you see listed under Microsoft Excel Objects"

Which I tried, but not being an Excel expert got lost....
Could somebody please advise in laymans terms for me.

Thanks in advance,
Deegz

Follow these instructions Deegz.

1. Go into the Visual Basic Editor (Alt + F11)
2. Ensure the Projects Window is Visible: View >> Project Explorer or Ctrl + R
3. Double click on the worksheet that you are trying to rename
4. Select worksheet from the dropdown box where it currently says (General)
5. In the second dropdown list (to the right of the first one) select 'SelectionChange'
6. Paste in the following code (exclude the link at the bottom). I hope this helps you.

On Error GoTo EH

If Range("C53") = "" Then Exit Sub

If ActiveSheet.Name <> Range("C53") Then ActiveSheet.Name = Range("C53")
Exit Sub
EH:
MsgBox "The value is cell C53 has created an error" & vbCr & vbCr & "Description: " & Err.Description