Disable AutoDate

  • Thread starter Thread starter Hitesh Zinzuwadia
  • Start date Start date
H

Hitesh Zinzuwadia

How to disable Auto Date function(The value updates
automatically to todays's date ).
I want to presereve the last opened date in sheet.
 
Hitesh,

Remove the formula and either manually type in the value, use a macro
to put the value in, or use an event to put the value in.

But, today's date _is_ the last time it was opened. If you want to
record the last time it was _modified_, then use the workbook's
sheetchange event.

HTH,
Bernie
 
Back
Top