rename sheet automatically
 

Hi new to excel and just want to rename the sheet automatically using a name
in a cell on the spreadsheet.

Thanks in advance

rename sheet automatically
 

One way:

put this in your worksheet code module (right-click the worksheet tab
and choose View Code):

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count 1 Then Exit Sub
If .Address(False, False) = "A1" Then
On Error Resume Next
Me.Name = .Text
On Error GoTo 0
End If
End With
End Sub


Change the cell reference to suit.




In article , "Tami"
wrote:

Hi new to excel and just want to rename the sheet automatically using a name
in a cell on the spreadsheet.

Thanks in advance

rename sheet automatically
 

Do you mean something like this ...

ActiveSheet.Name = ActiveCell.Value

or something more complicated?

"Tami" wrote in message
...
Hi new to excel and just want to rename the sheet automatically using a
name
in a cell on the spreadsheet.

Thanks in advance

rename sheet automatically
 

Hi,


Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Me.Name = Range("A1").Value
On Error GoTo 0
End Sub


--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--