Custom Footer's

  • Thread starter Thread starter racer25
  • Start date Start date
R

racer25

Hi Guys

Is there a way of everytime I create a new book that it creates b
default. The following custom fields as footer on every sheet.

File Name
File Location
Sheet Tab
Date & Time.

Thanks in advance.

Ro
 
You can create those fields as you want them and save the sheet as sheet.xls
and put it in your XLStart folder. This then becomes your default sheet.

doco
 
You could create a book.xlt template file and store it in your XLStart folder.

And when you create that workbook, you'll have to file|page setup for each of
the worksheets in that workbook.

sheet.xlt also stored in your XLStart folder will be used as the template when
you add a new worksheet to an existing workbook.

But be aware that xl2002 was the first version to have the ability to put the
path in the footer (via builtin tools).

John Walkenbach has an addin you may want to try:
http://j-walk.com/ss/excel/files/addpath.htm

John's addin doesn't do all the things you want, but the code is unprotected.
You could modify it to do all you want.
 
Back
Top