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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I add a future autodate 2
how do I get autodate to stay the date it was saved 3
Isse Date & Expiry dates 1
insert date automatically changes previous dates to new date? 2
Function to Return a Date Value Q 4
Excel Message box with days of month & date. 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Back
Top