function that will update worksheet names

[c991257]

Hi,

I have a workbook that has 36 worksheets that all function as holidayschedules. Additionally there are two worksheets that function as a master data sheet and another that works as a helper/info sheet.

In the master data sheet I have a startdate which the 36 sheets refer to and then adds the correct amount of days to give the first day of that particular month.

The 36 sheets are supposed to be named
MMM-YY

How do I have excel automatically rename the sheets if the startdate changes? The startdate can only change in yearly increments and will always start at 01-Jan.

/Møller

[Leith Ross]

Hello c991257,

Before adding this macro to the worksheet that contains the start date of 01-Jan, you will need to change the cell address in the macro to match the start date's cell address. It is marked in red.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Save the macro in your Workbook using CTRL+S

Sincerely,
Leith Ross

[c991257]

Thanks Ross,

This actually leaves me with a new issue, which is that I actually won't be able to link between the different sheets when their names change.

Unless I make a link to another page that lists the pagenames but that will really be a mess.

As I understand it Excel can't link to next sheet or previous sheet.

I probably need to find another solution.

/Møller