Sheetname = Cell content ........ is it possible?
Great code!!! it does exacly want i want to do!!!
Thanks a LOT Gord!! :-)
SpeeD
-----Original Message-----
SpeeD
This code placed in a Worksheet Module will
automatically change the tab name
when A1 is altered.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address(False, False) = "A1" Then
On Error Resume Next
Me.Name = Target.Value
On Error GoTo 0
If Me.Name < Target.Value Then _
MsgBox Target.Value & _
" is not a valid sheet name or is a
Duplicate "
End If
End Sub
Gord Dibben Excel MVP - XL97 SR2 & XL2002
On Wed, 30 Jul 2003 17:21:28 -0700, "SpeeD"
wrote:
Hi guys.
I´m having trouble with the following:
I need that the sheetename (tabname) can be updated
(renamed) via the content of a cell (a1). If the valeu
of
the cell changes the name changes. It would be great if
it was automatic, if not i could create a macro to
update
whenever the user wanted.
Thanks a lot!!!!
SpeeD
.
|