Default Chart Footers

[Jack]

Ladies and Gents Hi

Each time I print a chart or a table I want to keep track
of the date printed and the file name used. So I insert
them into the footer. I do this each I print something.
How do I default to a specified footer so that each time I
print the footer info is there?

Thanks

Jack

 

[Nick Hodge]

Jack

Workbook level settings can be made 'default' by opening a single-sheeted
workbook, making the settings and saving it as an excel template called
book.xlt in you xlStart folder. This will replace the defaults in Book1.xls
that normally opens with Excel.

For sheet level settings. (That is when adding new sheets to a workbook), do
the same but save as sheet.xlt

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Jack]

Nic

Thanks for the response. Great ti

Jack