| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel automatically insert current date in a cell? | Excel Worksheet Functions | |||
| Insert Current Date when cell is empty?? | Excel Worksheet Functions | |||
| How can I check a cell for current date and insert it if blank? | New Users to Excel | |||
| Any quick key to insert current Date and Time? | Excel Discussion (Misc queries) | |||
| How to insert a current date | Excel Discussion (Misc queries) | |||
Threaded Mode
