View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Veronica Veronica is offline
external usenet poster
 
Posts: 19
Default Insert Current Date on a Sheet 1 Tab

Good morning.

I have been trying to put a macro in place that will rename Sheet 1 tab to
the current date, every day, in many different new workbooks created daily.
I know the function =TODAY() however I can't seem to get that function to
take on the tab itself. I see that you can Insert an Excel Macro on the tab,
but I don't know how to create this either. I can get the Tab to read Macro1
- but then I don't know how to write that Macro.

I appreciate any input!
--
Thanks! Veronica.