| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update Date, Time Only Upon Save
Is there anyway to set up cells that use the Today () and/or Now ()
functions so that they only update when I re-save the file. Right now without doing anything but opening, the day and/or time always changes to the current date and time. I don't want that to happen. Thanks...........Paul C. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Update Date, Time Only Upon Save
Hi,
No you can't do it with the NOW() formula but you can use the before save workbook event. Alt +F11 to open Vb editor. Double click 'ThisWorkbook' and paste the code beloew in on the right. Change the sheet and cell to suit Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Sheets("sheet1").Range("A1") = Now End Sub Mike "Paul Calcagno" wrote: Is there anyway to set up cells that use the Today () and/or Now () functions so that they only update when I re-save the file. Right now without doing anything but opening, the day and/or time always changes to the current date and time. I don't want that to happen. Thanks...........Paul C. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with auto update of date and time | Excel Worksheet Functions | |||
| auto update of date and time whenever changes are made to a xcel s | Excel Worksheet Functions | |||
| auto update of date and time whenever changes are made to a xcel s | Excel Worksheet Functions | |||
| How do you continuously update time and date in an Excel cell? | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
Linear Mode
