setting tab name for worksheet

[Jan Eikeland]

hi.
Cant figure how to set name on diffrent worksheets.
any help?

thank you
regards jan

 

[Amit Shanker]

Just double click on the sheet tab and start typing the new name. When
finished, hit Enter.

Amit

 

[Ricky M. Medley]

in vba
thisworkbook.worksheets("<oldname>").name = "<newname>"

ricky

 

[Don Guillett]

activesheet.name="Whatever"

 

[Gord Dibben]

Jan

Sub sheetname1()
ActiveSheet.Name = Format(Now(), "dddd-mmm-yy")
End Sub

Sub sheetname()
ActiveSheet.Name = Range("c1")
End Sub

Gord Dibben Excel MVP