Udating the &[Date] only when changes are made

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

Guest

I'm trying to find out if there is a way to use the &[Data] in the header,
but only have it update to the current date if the document is changed.
Currently using this feature the date is updated to the current date whenever
you open the document, such that even if you just wanted to print it the date
would change to the current date. If there is a way to do this not using the
&[Date] option I would be curious about that too. THANKS
 
You would have to do that with some event macros: a Worksheet_Change that puts
a number in a cell to act as a flag that the worksheet has been changed; the
other a Before_Print macro that checks the flag and sets the header
appropriately.


On Fri, 5 Nov 2004 10:51:06 -0800, "Excel Curious" <Excel
 
You must log in or register to reply here.

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

Excel Message box with days of month & date. 1
If/Then Formula Using Dates 1
Excel Dragging countif formula with changing criteria 3
Can excel update date when document last changed? 1
Update a date cell when a target cell change.... 5
How do a set the current date to change in cell everyday 1
STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL 1
Current date 2

Back
Top