Mass rename tabs

**kisboros** · 02-09-2010, 05:19 PM

I have 4 employees by 52 weeks tabs in a workbook. The first 4 tabs are as follows:
Pat 010810
Dan 010810
Max 010810
Ann 010810

I would like some method (maybe VBA?) that I can rename the subsequent tabs, having the same names but the date with a seven day increment; i.e.the next tab would show Ann 011510, etc.

I don't know how to code, but can get to the VBA page and copy really well.

Thank you very much for any help with this.

**karan** · 02-09-2010, 06:13 PM

Hi kisboros,

This macro will do your job.

Please Login or Register  to view this content.

Refer the attached file. Don't forget to enable macros & make sure that the first four sheets of your workbook are what you mentioned.

Regards,
Karan

**DonkeyOte** · 02-09-2010, 06:23 PM

If you have dependencies across sheets it's probably worth toggling calculation as part of the process...

**kisboros** · 02-09-2010, 07:11 PM

Hi Karan,
Do I understand it correctly that I can just run your macro for my purpose?
Thank you very much,
Eva

**kisboros** · 02-09-2010, 07:12 PM

Hi Donkyote,
For the time being there are no dependencies; however, if there were, what does your instruction exactly mean?
Thanks very much,
Eva

**kisboros** · 02-09-2010, 07:29 PM

Hi Karan,
I copied and pasted your code into VBA and it worked like a champ! Thanks so much. I guess it would be beneficial to take a VBA class!
Eva

**karan** · 02-10-2010, 12:22 AM

Hey,

I am glad I could help.

If this takes care of your problem, please modify the original post & mark it as solved.

Regards,
Karan

**DonkeyOte** · 02-10-2010, 03:49 AM

Originally Posted by kisboros

For the time being there are no dependencies; however, if there were, what does your instruction exactly mean?

well... put simply:

Originally Posted by CharlesWilliams

Changing the name of a worksheet or moving it will trigger a recalculation in Automatic mode.
In Manual calculation mode, the statusbar will show "Calculate" ONLY if any formulae on any other sheet refer to the sheet with the changed name/position.

for more info. on Volatile actions triggering recalculation see the link in my sig. (from which above quotation is taken)