Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time date stamp | Excel Worksheet Functions | |||
Date-time stamp | Excel Discussion (Misc queries) | |||
Date-Time Stamp | Excel Discussion (Misc queries) | |||
date/time stamp | Excel Worksheet Functions | |||
Date time stamp | Excel Programming |