freeze today()

  • Thread starter Thread starter as_sass
  • Start date Start date
A

as_sass

Hi,

Does anybody know a way how to freeze the today() function?
I want the current date to be inserted in a cell only once when th
user opens the file for the first time.
When the workbook is closed and then opened again, it should give m
the exact same date.

Thanks!

a
 
put this macro in your ThisWorkbook module.

Sub workbook_open()
sheets("yoursheet").range("a1")=date
end sub
 
correct you are. Change to

If Not IsDate(Sheets("sheet9").Range("a1")) Then _
Sheets("sheet9").Range("a1") = Date
--
Don Guillett
SalesAid Software
(e-mail address removed)
Marcotte A said:
Actually, I believe Don's solution is incomplete. Won't the macro execute
Click to expand...
everytime the workbook is open and rewrite the (new) current date into A1?
 
Back
Top