Setting Tab Names To Dates In Spreadsheet

C

Chris

I have a large workbook (150 sheets). In Sheet 1, Cell A1, I have the first
date (example: 01/01/06). I have Sheet 2, Cell A1 set to take the result of
Sheet 1, Cell A1 and add 1 to it to get 01/02/06, Sheet 3 adds 1 to sheet 2's
to get 01/03/06 and so on.

How can I set up the sheet tabs to automatically rename themselves when I
change the date in Sheet 1, Cell A1. I want it to change all the tabs
without having to go into each one and pressing enter or double-clicking them
to make the tabs change.
 
G

Gary''s Student

Is the tab name in any way based upon the date in A1? Remember that a tab
name cannot have a / in it.
 
C

Chris

Thanks. That works great. However, one last question. When I do the update
of the date and then run the macro, it pops up a message for each spreadsheet
that is to be changed. This is the situation.

Date format is 01/01/06. Same date type format for the rest of the sheets.
When I run the macro, it pops up with a pop-up message saying 1-1-2006 then
the OK button. When I select OK, it makes the first tab 1-1-2006, then pops
up with another one for the second sheet (1-2-2006), and continues for the
rest of the 150 sheets. Is there a code format that I can put into the macro
that will set it just like 01-01-06 without me a) getting it to require the
MM-DD-YYYY format and b) to prevent it from popping up the message popup
window for each spreadsheet?
 
Top