Ps. the personal.xls(*) file that you described is usually used to contain
macros that the user wants available each time excel opens.

Tim879 wrote:

Not sure with 2007, but with all other excel versions... if you have a
personal.xls file then you can store your default footer there.

go to Window - Unhide and select personal.xls.

set the footer as you want and then re-hide the workbook (Window -
Hide)

if you don't have a personal.xls file... you can do the following to
create one...

- Close any and all open Excel workbooks
- Start Excel
- Click menu item Tools|Macro
- Click Record New Macro...
- Click the down arrow In the "Store macro in:" list box
- Click on Personal Macro Workbook
- Click OK
Do something simple to create the macro...
- Click in cell B1
- Press the Delete key
- Click in cell A1
- Click on the square button in the Stop recording tool
- Click the X in the top right hand corner of the Excel window to
close it (or press <Alt<F4)
- Click Yes to respond to "Do you want to save the changes you made
to the Personal Macro Workbook? If you click Yes, the macros will be
available the next you start Microsoft Excel -
- Click No to respond to "Do you want to save the changes you med
to 'Book1'?
Start Excel
(Copied from http://techinfo.laurenceholbrook.com...lWorkbook.html)

On Jan 14, 11:01 am, Hanne wrote:
Is there a way to set a footer as default any time you open a new Excel
workbook?
I'm using 2007

--

Dave Peterson