got it!!!!!!!!!!!!
cant thank u enough!!
Disri

"Rick Rothstein (MVP - VB)" wrote:

You will need to use worksheet event code to do that. Right-click the
worksheet's tab and select View Code from the popup menu that appears, then
copy/paste this code into the code window that appeared...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then ActiveSheet.Name = Target.Value
End Sub

Change the reference to "$A$1" to the absolute address of the cell you
actually want to use. Then, whenever you change the text in that cell, the
worksheet tab will be changed to whatever you typed into it.

Rick


"des-sa" wrote in message
...
please help
how do i give a tab of a worksheet the same name as a cell in the
worksheet,
automatically