Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheetname = Cell content ........ is it possible?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheetname = Cell content ........ is it possible?
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 "SpeeD" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheetname = Cell content ........ is it possible?
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 automatically change the tab name when A1 is altered. Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Address(False, False) = "A1" Then On Error Resume Next Me.Name = Target.Value On Error GoTo 0 If Me.Name < Target.Value Then _ MsgBox Target.Value & _ " is not a valid sheet name or is a Duplicate " End If End Sub Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Wed, 30 Jul 2003 17:21:28 -0700, "SpeeD" wrote: 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what's the function to return a sheetname in a cell in Excel? | Excel Worksheet Functions | |||
Automatically update SheetName in workbook sub if SheetName changes | Excel Discussion (Misc queries) | |||
Using a cell to reference sheetname in vlookup function | Excel Worksheet Functions | |||
Accessing the sheetname in a cell | Excel Worksheet Functions | |||
can formula to read sheetname from a cell? | Excel Worksheet Functions |