setting tab name for worksheet

  • Thread starter Thread starter Jan Eikeland
  • Start date Start date
J

Jan Eikeland

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

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

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

ricky
 
Jan

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

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

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

validation 3
Open Specific Worksheet Using Button Form Control in Excel 0
Selecting a worksheet 4
Dynamic list based on sheet names 2
shorten sheet name 4
Delete range of Worksheets 4
How to copy worksheet template into multiple worksheets 1
Selecting a range after activating a worksheet 3

Back
Top