TomW wrote: > 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. >
I guess I've have to look into macros then. I've never used them before in an office package. tnx jk -- Use OpenOffice.org <http://www.openoffice.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
