S
Seanie
What code could I use to automate these two tasks:-
1) Change the Active Sheet tab colour to: Blue if the sheet
immediately to the left is Yellow or Yellow if the sheet immediately
to the left is Blue
2) Rename the Active Sheet to "the name of the sheet immediately to
the left" + 7. The format of the sheet is dd-mm-yy, so if the sheet to
the left is 17-05-09 my new Active Sheet would be 24-05-09
If (2) above is even possible
Thanks
1) Change the Active Sheet tab colour to: Blue if the sheet
immediately to the left is Yellow or Yellow if the sheet immediately
to the left is Blue
2) Rename the Active Sheet to "the name of the sheet immediately to
the left" + 7. The format of the sheet is dd-mm-yy, so if the sheet to
the left is 17-05-09 my new Active Sheet would be 24-05-09
If (2) above is even possible
Thanks