Ugh, you could have mentioned earlier that it needed to stay the same
even if the workbook closed. In that case, you'll probably need to
write more event handlers.

--JP


On Sep 24, 2:46*pm, BC wrote:
JP,
It didn't work. *Closed and reopen and the time updated!
--
BGC



"JP" wrote:
A bit of programming would work. Put this code in the sheet module
behind the workbook:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
* Range("B1").Calculate
End If
End Sub

--JP