ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Static Dates in Footers (https://www.excelbanter.com/excel-worksheet-functions/5410-static-dates-footers.html)

Bruce November 1st 04 05:23 AM

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?

Frank Kabel November 1st 04 12:07 PM

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?



All times are GMT +1. The time now is 09:29 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com