Thank you it works but when I protect the sheet it errors out. Is there a way to keep it protected and have the macro work without the user being able to maunually update the time stamped field?