Now() function question

[Greg Gensicki]

Is there a function that will return the same time anytime the spreadsheet
is reopened, unlike the Now() function?

 

[David McRitchie]

Hi Greg,

You can enter a constant
Date using shortcut Ctrl+; (semi-colon)
Time using shortcut Ctrl+SHIFT+: (colon)

more on shortcuts on my keyboard shortcuts
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

If you want to have a date or time entered automatically with
a macro when you provide data in another column you can
use an Event macro see
http://www.mvps.org/dmcritchie/excel/event.htm

 

[Tushar Mehta]

If you want the time the workbook was opened, use

In the Workbook code module, enter:
Option Explicit

Private Sub Workbook_Open()
OpenDateTime = Now()
End Sub

In a standard module, enter:
Option Explicit

Public OpenDateTime As Date

Public Function WorkbookOpenTime() As Date
WorkbookOpenTime = OpenDateTime
End Function

Now, use =WorkbookOpenTime as a function in any worksheet cell.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions