Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save Date & Time
Does anyone know of a way to insert the last save date and time in a cell in
an Excel worksheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save Date & Time
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 DTHIS www.nickhodge.co.uk "mickey" wrote in message ... Does anyone know of a way to insert the last save date and time in a cell in an Excel worksheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save Date & Time
Thanks Nick
"Nick Hodge" wrote: 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 DTHIS www.nickhodge.co.uk "mickey" wrote in message ... Does anyone know of a way to insert the last save date and time in a cell in an Excel worksheet? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Save Date & Time
Pleasure
-- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "mickey" wrote in message ... Thanks Nick "Nick Hodge" wrote: 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 DTHIS www.nickhodge.co.uk "mickey" wrote in message ... Does anyone know of a way to insert the last save date and time in a cell in an Excel worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Time Stamp Dilemna | Excel Discussion (Misc queries) | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
change date based on time | Excel Discussion (Misc queries) | |||
Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
date and time | New Users to Excel |