Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I link the worksheet tab to a cell in the worksheet?
I want to link the tab of the worksheet to a cell. I type in something
different into a cell and the tab at the bottom automatically changes... can Excel do that for me? |
#2
|
|||
|
|||
"Husker87" wrote in message
... I want to link the tab of the worksheet to a cell. I type in something different into a cell and the tab at the bottom automatically changes... can Excel do that for me? A macro can. Rightclick the sheet tab, select "View Code". Paste this into the worksheet module: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo 100 If Selection.Cells.Count 1 Then Exit Sub If Target = "" Then Exit Sub If Target.Address = "$A$1" Then ActiveSheet.Name = Target End If Exit Sub 100: MsgBox "Invalid sheet name." End Sub Press ALT+Q to return to Excel. NB: assumes "a cell" = A1. HTH, Andy |
#3
|
|||
|
|||
Or you could just see the reply J E McGimpsey posted in misc, already.
:-[ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
how do i link a number of worksheets to one master worksheet? | Excel Worksheet Functions | |||
how do i copy formula and change worksheet instead of cell | Excel Worksheet Functions | |||
Link to a cell in another workbook by name rather than absolute c. | New Users to Excel | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |