Sheetname = Cell content ........ is it possible?

  • Thread starter Thread starter SpeeD
  • Start date Start date
S

SpeeD

Hi guys.

I´m having trouble with the following:

I need that the sheetename (tabname) can be updated
(renamed) via the content of a cell (a1). If the valeu of
the cell changes the name changes. It would be great if
it was automatic, if not i could create a macro to update
whenever the user wanted.

Thanks a lot!!!!

SpeeD
 
A subroutine like this would do the renaming:

Sub NameSheets()
Dim someSheet As Worksheet
For Each someSheet In ThisWorkbook.Sheets
someSheet.Name = someSheet.Cells(1, 1).Value
Next someSheet
End Sub

You could have a second subroutine fired by a sheet change or some other
event and have it call the sub above if that is what you want for
automation.

Steve


Hi guys.

I´m having trouble with the following:

I need that the sheetename (tabname) can be updated
(renamed) via the content of a cell (a1). If the valeu of
the cell changes the name changes. It would be great if
it was automatic, if not i could create a macro to update
whenever the user wanted.

Thanks a lot!!!!

SpeeD
 
Great code!!! it does exacly want i want to do!!!

Thanks a LOT Gord!! :-)


SpeeD


-----Original Message-----
SpeeD

This code placed in a Worksheet Module will
Click to expand...
automatically change the tab name
 
Back
Top