When starting excel

[Chris Jones]

Hi there

My problem is that i need excel to start with the layout
that i have made every time,(with company header and
footer).
Half off the problem is solved, but i also need to get
excel to start with our layout when a user press the new
file button on a worksheet, is this possible??
thanks in advance

Chris

 

[EZ Money]

Create a workbook formatted the way you want it and save as book.xlt
(template) in your XLStart directory. Replace the file currently there with
that name when prompted.

 

[Gord Dibben]

Chris

From Help>Index>Templates

About templates
To create new workbooks that already have your preferred formatting, you can
base the new workbooks on a template. A template can include formatting,
styles, standardized text such as page headers and row and column labels,
formulas, Visual Basic for Applications macros, and custom toolbars.

Workbook and worksheet templates

Default workbook template
You can create a default workbook template. This template defines the
formatting or content of the new workbooks that open when you start Microsoft
Excel. Workbooks you create by clicking New or by selecting the workbook
template in the Templates dialog box (General Templates..., New Workbook task
pane) are based on the default workbook template. The default template for
workbooks is called Book.xlt.

You can create additional custom workbook templates designed for specific
tasks and projects.

Default worksheet template
You can create a default sheet template.

This template defines the formatting and content of the default worksheets you
insert with the Worksheet command (Insert menu). The default template for
worksheets is called Sheet.xlt.

From Gord......

Store these two *.XLT's in your XLSTART folder.

Gord Dibben Excel MVP XL2002