Pete634
05-28-2007, 03:21 PM
Hi,
Can anyone give me a simple code to add a named workbook e.g. "TEST" with only one worksheet "A", but in doing so I do the code MUST NOT
1. save the "TEST" workbook
2. alter the number of sheets available for future new workbooks because of this code (because this will be used in a multi-user environment, and you know how stroppy people can get if suddenly when they click create new workbook they get only 1 sheet instead of 3, or 10 or 16!)
The "TEST" workbook is purely to be used as a dump to temporarily store data, which I don't want to keep in my main workbook.
Please help !!
Can anyone give me a simple code to add a named workbook e.g. "TEST" with only one worksheet "A", but in doing so I do the code MUST NOT
1. save the "TEST" workbook
2. alter the number of sheets available for future new workbooks because of this code (because this will be used in a multi-user environment, and you know how stroppy people can get if suddenly when they click create new workbook they get only 1 sheet instead of 3, or 10 or 16!)
The "TEST" workbook is purely to be used as a dump to temporarily store data, which I don't want to keep in my main workbook.
Please help !!