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