Update: Date

[Decreenisi]

Hi,

I have a speadsheet that I need to track when it was last used. In cel
A1 is the "Last Reviewed", In cell B2 is a date. Is there any way when
saving / closing the sheet that the B2 date is updated, so that when
you open it, you can see the last date it was opened. I have tried
=TODAY() ect but that keeps updating the current date.

Any thoughts ?

Thanks.

Duncan.

 

[Alan]

Hi,

I have a speadsheet that I need to track when it was last used. In cel
A1 is the "Last Reviewed", In cell B2 is a date. Is there any way when
saving / closing the sheet that the B2 date is updated, so that when
you open it, you can see the last date it was opened. I have tried
=TODAY() ect but that keeps updating the current date.

Any thoughts ?

Thanks.

Duncan.

Duncan

Use the Workbook_BeforeClose event in VBA to enter today's date so
that it tracks when the workbook was closed rather than opened. That
way you will be able to see the last user's date.

A.