Database version control

[rireland]

We have a club membership database in Excel 2003. Unfortunately too many people can change it and we sometime use an old version for a mailout when there is a later version around. We have no easy, foolproof way of establishing which is the latest version.

Is there a way that a cell in the database can automatically have the date & time it was last changed (NOT last time it was read - Windows does that). Also a user name.
Failing that, is it possible to detect when anything has changed & when you try to close the file it requests a date & user which have to be entered before it closes ( this relies on the user putting in valid info but at least it's a start).
Ideally when you re-open the file it should say in A1, A2 - last changed .... by .....

Richard

 

[Airfix9]

I have found the error and it is my mistake!

Code should read:

    lrow = Sheets("Data").Range("A65536").End(xlUp).Offset(1, 0).row

What kind of fool am I?

 

[rireland]

Perfect - thanks
Richard