Hi

not sure if i'm missing something here, but if in your macro it has
something along the lines of


'your current code
Range("A1").value = Format(NOW(),"dd/mm/yyyy")
'your current code

every time you run the macro, the date of running the macro will be inserted
into A1

Cheers
JulieD




"Spyder" wrote in message
...
I am building a macro and would like the macro to update a cell to say
"Data
Locked - <date when macro was run". I have tried to used the CTRL+;
command
to insert the date, but when recording the macro, the actual date text is
recorded and I am stuck with a date that is hardcoded to the time I built
the
macro. Any thoughts?

Thanks!