If you don't want to do it manually (what the heck... 12 stupid changes),
then you need VBA code for it.
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"Vicky P" wrote:
I want to rename the tabs of a new work book with the months of the year jan
09 to dec 09 without having to do it individually.
I'm sure it can be done by select all tabs - but then what??