Hi

Take a look at the code in the sample file I created for producing a Monthly
Workbook.
You can find it at
http://www.contextures.com/excelfilesRoger.html
the file is
http://www.contextures.com/CreateMthlyWkbks.zip

Modifying that code should do what you want.
--
Regards
Roger Govier

"mastermk" wrote in message
...
Is there a way I can put the DATE on the 3/4th Tab, and have each Tab
after
it Auto put the next Date on them, having enough tabs for a month + a few
main page tabs.

Thanks
Mastermk

__________ Information from ESET Smart Security, version of virus
signature database 4527 (20091020) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4527 (20091020) __________

The message was checked by ESET Smart Security.

http://www.eset.com