H
Hellmut
I would like to always put a standard footer on my Excel spreadsheets in
Office 2007. How can that be done?
Office 2007. How can that be done?
J
JP
You could record a macro of yourself putting in the footer you want on
your spreadsheet, then use it in the Workbook_Open event for your
personal.xlsb workbook.
HTH,
JP
your spreadsheet, then use it in the Workbook_Open event for your
personal.xlsb workbook.
HTH,
JP
D
Dave Peterson
Can't you put the standard footer on each worksheet in your book.xlt template
workbook and store it in the XLStart folder?
Same as previous versions of excel????
workbook and store it in the XLStart folder?
Same as previous versions of excel????
J
JP
Dave do you not use 2007 either?
--JP
--JP
D
Dave Peterson
I have it installed on a Virtual PC. If I want to run it, I have to start the
VPC and then start xl2007. And for the most part, that's just too much work
<vbg>.
I use xl2003 for almost everything.
VPC and then start xl2007. And for the most part, that's just too much work
<vbg>.
I use xl2003 for almost everything.
B
BoniM
You need to create a new, default workbook template and/or a new, default
worksheet template.
Open a new blank workbook and set up the footer for all of the worksheets
(and whatever else you find yourself changing for every workbook – in my own
I have also switched the layout to landscape, for example). Click Save as
and change the file type to Excel Template (*.xltx). Change the file name to
book.xltx and save it in the XLSTART folder under your office installation
folder. (Usually C:\Program Files\Microsoft Office\Office12\XLSTART). This
will take care of any new workbooks you open, if you also want it to apply to
new worksheets added to a workbook, however, delete all but the first sheet
in a new blank workbook, set that sheet up as desired and save it as
sheet.xltx in the same folder.
worksheet template.
Open a new blank workbook and set up the footer for all of the worksheets
(and whatever else you find yourself changing for every workbook – in my own
I have also switched the layout to landscape, for example). Click Save as
and change the file type to Excel Template (*.xltx). Change the file name to
book.xltx and save it in the XLSTART folder under your office installation
folder. (Usually C:\Program Files\Microsoft Office\Office12\XLSTART). This
will take care of any new workbooks you open, if you also want it to apply to
new worksheets added to a workbook, however, delete all but the first sheet
in a new blank workbook, set that sheet up as desired and save it as
sheet.xltx in the same folder.
B
BoniM
Yes, you can. Tho it's book.xltx. 
Dave Peterson said:
D
Dave Peterson
Or book.xltm????
Depending on if your template contains macros???
Depending on if your template contains macros???
B
BoniM
Yes - but if you have both - book.xltx will be the one used.
H
Hellmut
Thank you all who answered -- the detailed answer by BoniM was the most
useful one. It works fine.
useful one. It works fine.
J
JP
LOL sorry to hear it!
--JP
--JP