Today() function

  • Thread starter Thread starter DB
  • Start date Start date
D

DB

I have worksheet that uses the =today() fuction as
contents. The spredsheet is saved as a template opened
data entered then saved as a file. Several of these may
be saved in a day. The form is emailed to another office.
If they open it the same day the date is no factor but
if they don't open the file until the next day then the
date cell still relects the current day which should be
in this case the day before.

I want to use an automatic date feature like Today(), but
I need to be able to convert it to a value when the file
is saved. I need to do this automatically in a formula or
other. People using this form are not computer savy. To
manually copy/paste special as value or to run a macro to
do the same is not an option.

Can this be done within a formula or someway
automatically.

Thanks for any help
DB
 
I need to do this automatically in a formula or other ...
People using this form are not computer savy ...
copy/paste special as value or to run a macro to
do the same is not an option.
Click to expand...

Because they're not computer-savvy? (Who is?)

AFAI can see, you won't get =TODAY() to act non-volatile. Event code in
ThisWorkbook module, perhaps.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Range("A1") = Date
End Sub

HTH,
Andy
 
Back
Top