Name sheet tab by today's two digit date

A

Annette

How can I programmically name a sheet by today's date? I have a user that
has to process daily incoming spreadsheet and she attaches to a monthly
sheets and I thought it would be easier for her if she had a macro to run
the sheet name change.

Thanks!

Annette
 
T

Tom Ogilvy

activesheet.name = Format(Date,"dd")

demo'd from the immediate window:

activesheet.name = Format(Date,"dd")
? activesheet.name
02
 
Top