On Saturday 28 November 2009, Michael Adams wrote: > On Fri, 27 Nov 2009 19:43:23 +0000 > > Came this utterance formulated by bill purvis to my mailbox: > > On Friday 27 November 2009, Andreas Saeger wrote: > > > bill purvis wrote: > > > > I am working on a multi-sheet parts list spreadsheet and it would > > > > be really useful if I could automatically insert the date of the > > > > most change at the bottom of each sheet. I can see that I can > > > > enter the'current' date, but I'd really like the date at which any > > > > of the sheets were last modified. At present I have a hidden field > > > > on sheet1 and copy this to all the relevant cells, but then I have > > > > to unhide the cell, update the content, and re-hide it each time I > > > > change something. Is there such a function - I couldn't see it in > > > > the help list. > > > > > > > > Bill > > > > > > Type the address or name of the cell into the name box left of the > > > formula bar. > > > Then type into the formula bar: =NOW() F9 Enter Enter > > > > No good! I want to be able to open the spreadsheet and see when it was > > last modified - NOW() gets updated when you load a SS, otherwise it > > would be the answer. Thanks anyway! > > I understand that you are not looking for the date and time of the last > sheet-recalculation. But are you looking for the date when the file was > last saved, when a formula was last modified or when content was last > updated? > I am refining my thoughts on this. What I really want is to be able to load the spreadsheet and print off a copy and know when I last modified it. I am now thinking that the last time I saved it is sufficient for that purpose and I am about to start looking at using a script, invoked by the 'Save' event to update the cell. If you have any better ideas, I'd welcome them.
Thanks, Bill -- +---------------------------------------+ | Bill Purvis, Model Engineer | | email: [email protected] | +---------------------------------------+ --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
