freeze today()

[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

 

[Frank Kabel]

Hi
you need VBA for this. See:
http://www.mcgimpsey.com/excel/timestamp.html

 

[Don Guillett]

put this macro in your ThisWorkbook module.

Sub workbook_open()
sheets("yoursheet").range("a1")=date
end sub

 

[Don Guillett]

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)

Actually, I believe Don's solution is incomplete. Won't the macro execute

everytime the workbook is open and rewrite the (new) current date into A1?