Auto date each row

[hawk7890]

Good day,

I am looking for a way to have a date column that the rows will auto update anytime a change is done on it's respective row. Is there any way of doing this? I am using Excel 2003

thank you
marc

[Marcol]

In its' simplest form
This in the worksheet module

Please Login or Register  to view this content.

This will add/change the date in column A when anything is changed in columns B to the last column in your worksheet.

You could also substitute Now() for Date and format column A accordingly.

You will need to be more specific if you are to avoid unwanted changes.

[hawk7890]

thank you for the message, I checked your attachment and that is exactly what I am trying to do. But with different columns. What would the code look like if I had the date field in column F and it would update if a change is done on column A-E? Is there a way to lock column F (other than using protection) so it cannot be changed by the user?

Thank you
Marc

[Marcol]

Okay try this

Please Login or Register  to view this content.

[hawk7890]

Thanks again it works perfectly. I was wondering if there is a way to prevent the users from changing the date column. At the moment they are able to delete the date if they like. I tried by enabling protection but it generates an error if I enable it.

Thanks
Marc

[Marcol]

This will work if you unlock the cells you are allowjng to edit then protect the sheet.

Please Login or Register  to view this content.

Note the change to allow for a header row.

If you use a pasword the change Password:="" to Password:="Your Password" in both instances.