Date set to date the worksheet was last modified


Posted by Stephen Allenberg on January 11, 2002 6:19 PM

Mr Excel

This should be an easy one for you - if it is possible

I work on spreadsheets daily and then save them to
refer to them later or update them. What I would
like to achieve is :

When I actually work on a spreadsheet (not just
open it)- the date that I last worked on it will
automatically be recorded and only changed should
I update the contents of the worksheet

What I am trying to achieve is the last date that
the file was modified ie the latest file and to
preserve the date unless I modify the data.

Is there perhaps a Macro could use (I am well versed
at programming in Qbasic if this can be used)or is
there some simpler way as I don't intend getting
involved in Visual bacic and Excel programming.

I thank you for any assistance that you are
able to offer


Regards
Stephen Allenberg



Posted by Tom Urtis on January 11, 2002 9:27 PM