Dates

Resolved · Medium Priority · Version 2010

Wed 28 May 2014, 16:26 Delegate Faisal said...

Faisal has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Dates

How do we insert dates in our sheets which show the last time and date the sheet was saved?

Thu 29 May 2014, 13:54 Trainer Gary said...

RE: Dates

Hi Faisal

Thanks for getting in touch. As I expected with this problem, you have to use VBA code to retrieve this piece of information.

Press ALT+F11 to open the macro editor
Double click 'ThisWorkbook'
Paste this code

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = Now
End Sub

There is a good forum link here explaining the process:

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/insert-the-date-an-excel-workbook-was-last/c0c7335e-fc0d-43c7-b32d-215f84b452cc

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector