Date time stamp
Hi
you may put the following code in your workbook module
Private Sub Workbook_Open()
Worksheets("Sheet1").Select
Range("A1").Value = now
End Sub
--
Regards
Frank Kabel
Frankfurt, Germany
Erik wrote:
I am trying to place a date/time stamp in one cell that is updated
when the sheet is opened. What is the best way to do this? Erik
|