Linking a cell and a sheet name

[Mike R]

How do I link a cell to the sheet name. When I enter the name of a client I want that sheet be also named. I can quickly scan the sheet on a woorkbook and go directly to the desided client.

 

[Earl Kiosterud]

Mike,

You can paste the code below into the sheet module for the sheet.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then ' are we in client
name cell?
If ActiveSheet.Name = Sheet1.Name Then ' in case of grouped sheets
ActiveSheet.Name = Target.Value
End If
End If

Replace A1 with the name of your Client Name cell, and Sheet1 with the code
name of the sheet (from the VBE project explorer, not the name on the sheet
tab)
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

How do I link a cell to the sheet name. When I enter the name of a client

I want that sheet be also named. I can quickly scan the sheet on a
woorkbook and go directly to the desided client.

 

[tjtjjtjt]

Use the Insert|Name|Define Option to name a specific cell (or group of cells) on a specific worksheet. It will pick up the cell and worksheet by default

tj

 

[Mike]

Thank You very much. It did take a little for me to get it to work, but it was because of my lack of experience and knowledge. But it works now and works great. Thanks