Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bruce
 
Posts: n/a
Default 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?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automaticaly entering static dates Tinker Excel Discussion (Misc queries) 6 April 9th 05 12:53 AM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 09:43 PM
due dates Niki New Users to Excel 4 January 10th 05 05:11 PM
Entering dates in Excel 2002 DickG Excel Discussion (Misc queries) 3 January 9th 05 03:56 PM
I get wrong dates when i paste from a different sheet into a new s mmollat Excel Discussion (Misc queries) 2 January 6th 05 08:35 PM


All times are GMT +1. The time now is 07:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"