Ah. Never thought to right mouse on the Sheet tabs at the bottom.

This time, however, I get this message:
"Excel cannot insert the sheets into the destination workbook (although
my template has only 1 sheet, as per your instructions), because it contains
fewer rows and columns than the source workbook. To move or copy the data
to the destination workbook, you can select the data, and then use the Copy
and Paste commands to insert it into the sheets of another workbook."

Well, of course it does, because the idea was to preserve the "hidden"
attributes of certain columns. I don't know how it counts rows after one
has deleted all data, but I did that on the template to.

More ideas?

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Laurel

It will work the same as in XL2003.
Create the sheet you want as mentioned previously, starting from a new
workbook with a single sheet.
Round Office ButtonSave AsExcel WorkbookSave as TypeExcel
Templategive it a NameOK
Close the file just created

To use, in any new workbook, right click on Sheet tabInsertselect your
templaterename sheet to whatever you want.

Do note that if you have an old xls file that you have loaded in
Compatability mode in XL2007, you will not be able to insert your 2007
excel template sheet. You would need to have created one in XL2003 and
have available in your Templates folder.
--
Regards
Roger Govier

"Laurel" wrote in message
...
Thanks. I'm using Office 2007, so I had to go to HELP to figure out how
to create and use a template instead of following your script. But this
didn't tell me how to use a template on an existing workbook. In other
words, it seems like it's only good for starting a new workbook. The
HELP I used is below. Any ideas?


Create and use an Excel template
Show All
Hide All
To save time or to promote standardization, you can save a workbook as a
template (template: A workbook that you create and use as the basis for
other similar workbooks. You can create templates for workbooks and
worksheets. The default template for workbooks is called Book.xlt. The
default template for worksheets is called Sheet.xlt.) that you can use to
create other workbooks. In Microsoft Office Excel 2007, a template file
(.xltx) can include data and formatting, and a macro-enabled template
file (.xltm) can also include macros (macro: An action or a set of
actions that you can use to automate tasks. Macros are recorded in the
Visual Basic for Applications programming language.).

You can use one of your own templates to create a new workbook, or you
can use one of the many predefined templates that you can download from
Microsoft Office Online.

What do you want to do?

--------------------------------------------------------------------------------

a.. Create a template
a.. Use a template to create a new workbook

--------------------------------------------------------------------------------

Create a template
1.. Open the workbook that you want to use as a template.
2.. Click the Microsoft Office Button , and then click Save As.
3.. In the File name box, type the name that you want to use for the
template.
4.. In the Save as type box, click Excel Template, or click Excel
Macro-Enabled Template if the workbook contains macros that you want to
make available in the template.
5.. Click Save.
The template is automatically placed in the Templates folder to ensure
that it will be available when you want to use it to create a new
workbook.

Tip You can copy any Excel workbook into the Templates folder, then you
can use the workbook as a template without saving it in the template file
format (.xltx or .xltm). In Windows Vista, the Templates folder is
usually C:\Users\<your name\AppData\Roaming\Microsoft\Templates. In
Microsoft Windows XP, the Templates folder is usually C:\Documents and
Settings\<your name\Application Data\Microsoft\Templates.


Top of Page


Use a template to create a new workbook
1.. Click the Microsoft Office Button , and then click New.
2.. Under Templates, do one of the following:
a.. To base the workbook on a recently used template, click Blank and
recent, and then under Recently Used Templates, double-click the template
that you want to use.
b.. To base the workbook on an installed template, click Installed
Templates, and then under Installed Templates, double-click the template
that you want to use.
c.. To base the workbook on a template that you created, click My
templates, and then on the My Templates tab, double-click the template
that you want to use.
d.. To base the workbook on another workbook, click New from Existing,
and then double-click the workbook that you want to use.
Tip When you are connected to the Internet, you can also access
templates that are available from Office Online. Under Microsoft Office
Online, click a template category, and then under that category,
double-click the template that you want to download. If the template that
you want to download has been supplied by a member of the Microsoft
Office Online Community, you must click I accept to accept the License
Agreement for Community Templates Terms of Use before you can download
that template.


Top of Page

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi Laurel

I would open a new workbook and delete all except for Sheet1
I would create the sheet as I wanted it, with all the various columns,
row
heights etc., but with no data and save this as a Template
with FileSave asTemplatesMySheet

Then when required, InsertSheetMySheet

--
Regards
Roger Govier

"Laurel" wrote in message
...
... and row heights and orders of columns, so I can call them up at a
later time?