Wigi - thank you for answering
it is not so much that I can't rename 12 tabs manually - but I am such a
baby at this and I really do want to learn "how to do stuff"
In the future i may need to rename 365 tabs - then it would'nt be so easy -
so start small.
I've learnt such a lot - and its always a joy when you find something out
that makes life easier / quicker
I have opened VBA code - but what do you do when you are there??
"Wigi" wrote:
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??