Having input the current date in a cell I want to lock it
 

There's no event that fires when a data form closes, so you're probably
going to need to use a userform instead.


In article ,
Jim Mc <Jim wrote:

I am running a macro to check info inputted by the form command. I want to
add the date and time at the moment the form is closed. I can do this but the
date and time changes as time moves on. How can I lock this data?