How to enter last saved date in Excel workbook

Updated on

I am using Office Pro Plus 2010 and I wanted to have the last saved date displayed in my document for my records.  I found this simple method:

To modify a workbook you have to save it so we can use the before_save event
ALT+F11 to open vb editor. Double click ‘ThisWorkbook’ and paste this code in on the right. Change the sheet and range to suit
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets(“Sheet1”).Range(“A1”).Value = Now
End Sub

Similar Posts

Windows Server 2012 Standard WLAN Netgear WNA3100 USB

ByiUseful

I downloaded and installed the drivers for my Netgear WNA3100 usb adapter, inserted the device when prompted, nothing happened for a while.  I searched online (ethernet cable plugged in) and found that the feature needs to be enabled: Go to Server Manager  -> Features -> add a feature -> scroll to the bottom- > select…

MS Excel 2010 calculations not updating?

ByiUseful

Whilst using MS Excel I noticed that the calculations were not updating automatically, I have never experienced this in many years of using this software. Found the issue, under Formulas and Calculation Options just select automatic.  I opened a pricelist spreadsheet from a supplier and somehow that may have changed the setting. Link here