Hi,

Does anyone know if its possible to name a tab from a cell reference in a
worksheet.

I am developing a Excel spreadsheet to hold details of projects, each
project has a separate tab. I would like the tab to automatically rename
itself from the cell that the project number is typed into.....

Any help would be much appreciated.

Hi
in VBA with
with activesheet
..name=.range("A1").value
end with

"Phil12345678910" wrote:

Hi,

Does anyone know if its possible to name a tab from a cell reference in a
worksheet.

I am developing a Excel spreadsheet to hold details of projects, each
project has a separate tab. I would like the tab to automatically rename
itself from the cell that the project number is typed into.....

Any help would be much appreciated.

I have the same question but just want to link one worksheet tab name
automatically to a cell in the worksheet. Change the cell and the tab name
on the worksheet changes€¦ can you help with the VBA code for that? Many
Thanks€¦.

"Frank Kabel" wrote:

Hi
in VBA with
with activesheet
.name=.range("A1").value
end with

"Phil12345678910" wrote:

Hi,

Does anyone know if its possible to name a tab from a cell reference in a
worksheet.

I am developing a Excel spreadsheet to hold details of projects, each
project has a separate tab. I would like the tab to automatically rename
itself from the cell that the project number is typed into.....

Any help would be much appreciated.

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Target.Address = "$H$1" Then
Me.Name = Target.Value
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Husker87" wrote in message
...
I have the same question but just want to link one worksheet tab name
automatically to a cell in the worksheet. Change the cell and the tab
name
on the worksheet changes. can you help with the VBA code for that? Many
Thanks..

"Frank Kabel" wrote:

Hi
in VBA with
with activesheet
.name=.range("A1").value
end with

"Phil12345678910" wrote:

Hi,

Does anyone know if its possible to name a tab from a cell reference
in a
worksheet.

I am developing a Excel spreadsheet to hold details of projects, each
project has a separate tab. I would like the tab to automatically
rename
itself from the cell that the project number is typed into.....

Any help would be much appreciated.