freeze date stamp

  • Thread starter Thread starter icestationzbra
  • Start date Start date
I

icestationzbra

hello,

i am trying to use the now() function in such a way that once the
workbook has been saved, the time stamp freezes.

i am not successful.

is there another way?

thanks,

mac.
 
You can just use CTRL+; and it will insert the date for you, but to do as you
were trying you need VBA in the Before_Close event of the ThisWorkbook module to
insert the date as a value.
 
thanks to both of you.

for now, CTRL+; will work.

i was looking more towards a way of using NOW() or TODAY() in such a
way that, they should just perform their function once and then the
cell should freeze the value.

perhaps a way to freeze the output of a formula in a cell wherein the
formula resides, in such a way that the value does not refresh.

i would rather not use a macro. workbooks with macros are opened with a
touch of mistrust around here.

thanks,

mac.
 
Back
Top