work book sheets
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? |
work book sheets
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? |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com