Custom Footer's

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
 
D

doco

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
 
D

Dave Peterson

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.
 
Top