| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet Names as a Date
Hi
Is it possible to change the name of a worksheet tab to show the current year and another sheet to show the previous year? If it helps, each sheet has the correct year in one of the cells using the TODAY function. I expect the only way to do this is using the VB editor, but does anyone know the code to achieve this? Thanks Simon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find hidden names on an Excel worksheet ? | Excel Worksheet Functions | |||
| Tracking worksheet names in functions | Excel Worksheet Functions | |||
| Lookup cell value using list of worksheet names | Excel Worksheet Functions | |||
| Using worksheet names in formulas | Excel Discussion (Misc queries) | |||
| Transferring date from multiple worksheets to a "totals" worksheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
