With a Macro assigned to a Button you can copy and Paste Special/Paste Special/Paste (uncheck all but “Date & time”) of a dynamic “=NOW()” cell to another cell where it remains static, only changing when the Button is clicked. Just click the Button before saving the file.
