Insert Footer into Every New Workbook Automatically

hsnmef · May 12th, 2002, 05:40 PM

Forgive me for asking a question that I could have likely found the answer to by searching the previous posts, however, in my defense, I got an odd SQL error when I tried to search.

I would like excel to automatically insert a footer into each new workbook as soon as I open one. I know this can be done, and it involves the personal.xls and auto run or open, I just am not sure about exactly how to make it work.

Thanks!

Mark W. · May 12th, 2002, 05:46 PM

You can create an empty workbook with the desired footer and save it as Book.xlt into your XLStart folder. See the Excel Help topic for "Customize the defaults for a workbook or worksheet by using a template".

Qroozn · May 12th, 2002, 06:17 PM

The SQL error you are incountering is due to your search being to broad. make sure that if you use multiple words in your search than you check the "search for ALL of the terms".

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 12th, 2002, 05:40 PM	#1
hsnmef New Member Join Date: May 2002 Location: Houston Posts: 37	Forgive me for asking a question that I could have likely found the answer to by searching the previous posts, however, in my defense, I got an odd SQL error when I tried to search. I would like excel to automatically insert a footer into each new workbook as soon as I open one. I know this can be done, and it involves the personal.xls and auto run or open, I just am not sure about exactly how to make it work. Thanks!

May 12th, 2002, 05:46 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	You can create an empty workbook with the desired footer and save it as Book.xlt into your XLStart folder. See the Excel Help topic for "Customize the defaults for a workbook or worksheet by using a template".

May 12th, 2002, 06:17 PM	#3
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	The SQL error you are incountering is due to your search being to broad. make sure that if you use multiple words in your search than you check the "search for ALL of the terms".