Hi Kathy

I have created a file with some code which does this for you.
You can download a copy at
http://www.contextures.com/CreateMthlyWkbks.zip

--
Regards
Roger Govier

"kathy" wrote in message
...
is there a way to name workbooksheets automatically rather than each one
individually? need to have a workbook with a sheet in it for every day of
the month.. is tedious to rename all the sheets each month.. ideas?
please?