James Knott wrote:
TomW wrote:
James Knott wrote:
I currently use the =today() function in a spreadsheet. However,
I've noticed it always shows the current date. Is it possible to
have it show the date of the last save?
tnx jk
One solution would be the following:
If you assign a macro similar to the one listed below to the close
event of the worksheet, you can insert the current Date/Time into a
cell on the worksheet. The workbook events are accessible through the
tools:customize:events tab.
What I'm looking for is just the saved date, which is not necessarily
the same as the close date. That is, if I save the document, the date
shows that, and does not ever change, until I do another save later.
The =today() function will show last modify date, which is close enough,
but unfortunately also changes on re-opening the file, which is not what
I want. Is there any way to read the file modify date into the cell?
tnx jk
There is a event called "'Modified' status was changed". You can assign
the macro to that event.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
