View Single Post
Old 02-10-2008, 04:15 AM
deegz deegz is offline
Join Date: Feb 2008
Posts: 1
Default Automate Excel tabname

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,
Reply With Quote