rename sheet automatically

T

Tami

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

Thanks in advance
 
J

JE McGimpsey

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.
 
B

Bigwheel

Do you mean something like this ...

ActiveSheet.Name = ActiveCell.Value

or something more complicated?
 
S

Soo Cheon Jheong

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
_ _
^¢¯^
--
 
Top