Save Date & Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of a way to insert the last save date and time in a cell in
an Excel worksheet?
 
Mickey

You could use a workbook_Beforesave() event, like so

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

To get into workbook, right-click the workbook excel icon second down top
left and select view code, paste here

Change worksheet and cell ref to suit

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
Thanks Nick

Nick Hodge said:
Mickey

You could use a workbook_Beforesave() event, like so

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

To get into workbook, right-click the workbook excel icon second down top
left and select view code, paste here

Change worksheet and cell ref to suit

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"save as" 0
=NOW() 2
Workday Formula to include date 0
Save Date 1
Macro to Insert Current Date into cell - Macro to "Save As" 4
Importing cells frmom a calendar workbook 4
How do I display the most recent "modified" date in Excel sheets? 5
automatically show modified date? 2

Back
Top