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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert file last save date into excel 2007 footer 1
Header/Footer Date Format 2
As of date formula in a footer 3
Calculate Date in Footer 4
Change date format in Excel footer 2
Automatic update of footer macro 2
Date & Time Stamp for printing 1
Insert date, but keep static on archived 4

Back
Top