Default Chart Footers

  • Thread starter Thread starter Jack
  • Start date Start date
J

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
 
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)
 
Back
Top