Static Dates in Footers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I use &[Date} and &[Time] functions in my Excel 2000 footers. I want this
date to automatically update only when I have made edits to the document, not
every time I open it.

I want my printouts to reflect the "data as of" date (the date of the last
SAVE), and not the "printed on" date.

How do I do it?
 
Hi
this would require VBA (using an event procuedre such as
workbook_beforeprint). Dou you want to go this way?
 
Back
Top