Worksheet Tab value to change automatically

Praxis · May 9th, 2002, 01:59 PM

I wish to Link a Worksheet Tab so that the default name (Sheet1) would change automatically to match a value in a cell. The other scenario would be to change the value of the Worksheet Tab (Sheet1) and a cell from the sheet would change automatically to match the value of the Tab.

lenze · May 9th, 2002, 02:09 PM

Right click on the WorkSheet Tab and choose View Code. Paste in this code

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$4" Then ActiveSheet.Name = Target.Value
End Sub

Change $A$4 to the cell of interest

Praxis · May 10th, 2002, 06:52 AM

Thank you Lenze.. Your'e the man.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 01:59 PM	#1
Praxis Board Regular Join Date: May 2002 Location: Minnesota, USA Posts: 70	I wish to Link a Worksheet Tab so that the default name (Sheet1) would change automatically to match a value in a cell. The other scenario would be to change the value of the Worksheet Tab (Sheet1) and a cell from the sheet would change automatically to match the value of the Tab.

May 9th, 2002, 02:09 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Right click on the WorkSheet Tab and choose View Code. Paste in this code Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$4" Then ActiveSheet.Name = Target.Value End Sub Change $A$4 to the cell of interest

May 10th, 2002, 06:52 AM	#3
Praxis Board Regular Join Date: May 2002 Location: Minnesota, USA Posts: 70	Thank you Lenze.. Your'e the man.