Date on W/sheet Tab!

M

mellowe

Hi All

Is it possible to use VB code to re-name a worksheet tab with todays
date?

Say the w/sheet was called Core1 and after a macro has been run it
needs to rename Core1 to todays date is that possible?

thnx
 
M

Mark Lincoln

Sub ChangeSheetName()
Sheets("Corel").Name = Format(Date, "mm-dd-yy")
End Sub

Change the format to match how you want the date displayed. (Don't use
forward slashes.)
 
Top