View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wigi Wigi is offline
external usenet poster
 
Posts: 396
Default rename excel tabs months for year without doing it individually

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??