Check here

http://www.nickhodge.co.uk/tipstrick...okandSheet.xlt

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"hsjj" wrote in message
...
I want to set up my EXCEL so that it will automatically know I want a
footer
(with file name and date) instead of having to set it up everytime I have
a
new file to print.