I think this will work if I am correctly understanding what is trying to be done:


Cells(1, 1).value = now()


This should time stamp cell A1 and not update. It would just need to be used as a macro or as part of a macro.