Disable AutoDate

[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.

 

[Bernie Deitrick]

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