setting tab name for worksheet
 

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

thank you
regards jan

setting tab name for worksheet
 

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

Amit


"Jan Eikeland" wrote in message
...
hi.
Cant figure how to set name on diffrent worksheets.
any help?

thank you
regards jan

setting tab name for worksheet
 

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

ricky

"Jan Eikeland" wrote in message
...
hi.
Cant figure how to set name on diffrent worksheets.
any help?

thank you
regards jan

setting tab name for worksheet
 

activesheet.name="Whatever"

--
Don Guillett
SalesAid Software

"Jan Eikeland" wrote in message
...
hi.
Cant figure how to set name on diffrent worksheets.
any help?

thank you
regards jan

setting tab name for worksheet
 

Jan

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

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

Gord Dibben Excel MVP

On Thu, 11 Dec 2003 17:21:47 GMT, "Jan Eikeland" wrote:

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

thank you
regards jan