Date Function Prompting Save

[Amy Beryl]

Hi All -

I have a question about files that utilize the =Now() or =Today() functions. Is there a way to add in a current date function that doesn't prompt the user to save the file every time. Sometimes I bring up the file just to look at data in it and when I'm done it asks me if I want to save the file even though no data was changed. I think the file updates the date (or more specifically the time) within the date function and that constitutes a change to the file and thus asks for a save. Is there a way to have an auto-updating date function that dooesn't change after the first viewing in a day?

Amy

 

[Jonmo1]

Welcome to the board...

It would require VBA code, is that acceptable?


Press ALT + F11 to open the VBA editor.
Find the module on the left side labled ThisWorkbook - double click it.
Paste the following code (adjust sheetname and range to reflect where you want the date to go).

Private Sub Workbook_Open()
With Sheets("Sheet1").Range("A1") 'Adjust sheetname and range as needed
    If .Value <> Date Then
        .Value = Date
    End If
End With
End Sub

Save / Close / Reopen the book


Hope that helps.

 

[Amy Beryl]

I am not that sophisitcated with macros so I am uncomfortable installing this in spreadsheets that users who are even less sophisticated will be using. I take it there isn't a function that will display a date and not have an ever-updating time attached to it?

Thanks!

Amy

 

[Jonmo1]

Well, Today() does not contain the time...
But it's still volatile and recalculates upon opening.
And will prompt for save when closing.


There are no other functions to "automatically" put the date in a cell without prompting for save each time it's opened.
Sorry.