Date workbook changed

Hi Everyone,
I need some VBA code that will insert the date, into a specified cell on a specific worksheet, that the worksheet was last changed.

I have a worksheet named 'points'. If any cell on the worksheet 'points' is changed I need the date that the change took place to be put in cell A1.

I cannot use the Today() function because it will change when the workbook is opened even if no changes have been made to the worksheet.

Any help would be most appreciated.

Many thanks
Phil

Hi,

Following event macro should do the job ...
Go to worksheet tab
right click
select view code
copy code

Please Login or Register  to view this content.

HTH
Carim

Hi Carim
Many thanks for the code - it's just what I needed . It has solved a number of problems that I thought I would not be able to overcome.
Once again many thanks for your help.
Phil

You are welcome...

Thanks for the feedback

Carim