Is there a different function for Getting a Date?

[Guest]

I need a get date function for excel that will not execute everytime a cell is calculated. This includes the NOW() and TODAY() functions. Ideally I want to update a calander date in a spread sheet upon the opening of that sheet but not everytime I run a macro or calculate a cell. i have a complax macro that calculates many cells and really bogs down when NOW or TODAY is used

Thank you in advance

Jon

 

[Anders S]

Jon,

Private Sub Workbook_Open()
ThisWorkbook.Sheets("Sheet1").Range("E2").Value = Date
End Sub

Excel 2002

HTH
Anders Silvén

 

[Peo Sjoblom]

You could have a macro running every time you open that workbook?

Private Sub Workbook_Open()
Range("A1").Value = Now()
End Sub

press Alt + F11, in the project - vbaproject pane to the left, find your
workbook,
double click ThisWorkbook and paste something like the above. Press Alt + Q
to
close the VBE. Now every time you open that workbook A1 will update with
date and time

--

Regards,

Peo Sjoblom

I need a get date function for excel that will not execute everytime a

cell is calculated. This includes the NOW() and TODAY() functions. Ideally
I want to update a calander date in a spread sheet upon the opening of that
sheet but not everytime I run a macro or calculate a cell. i have a complax
macro that calculates many cells and really bogs down when NOW or TODAY is
used