Static Dates in Footers
 

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?

"Bruce" wrote:

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?