How do I set up worksheets to match?
Do you want to have a particular formatted and designed worksheet to be
inserted?
You can open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder. It now becomes
the default InsertSheet.
More can be found on this in Help under "templates"(no quotes).
Instructions are for Excel 2003 and earlier.
2007 is similar except you would save as SHEET.xltx
Gord Dibben MS Excel MVP
On Mon, 22 Jun 2009 11:30:01 -0700, DrNick48
wrote:
When I select the INSERT WORK SHEET function in a workbook, the 2nd and
subsequent worksheets don't match the first one. I've searched for WORKSHEET
TEMPLATE directions to no avail. of course, it IS a Monday... LOL
What am I missing?
TN X!!!
|