James Knott wrote:
I currently use the =today() function in a spreadsheet. However, I've
noticed it always shows the current date. Is it possible to have it
show the date of the last save?
tnx jk
One solution would be the following:
If you assign a macro similar to the one listed below to the close event
of the worksheet, you can insert the current Date/Time into a cell on
the worksheet. The workbook events are accessible through the
tools:customize:events tab.
TomW
Sub mcrDateModified()
' recorded by Thomas Webb
' date: 08/19/2007 15:59:56
'Assign current date/time to a variable.
Dim dateModified as date
dateModified = now()
'Selects the desired cell.
oCellRange = ThisComponent.Sheets.Daily2007.getCellRangeByName("B1")
ThisComponent.CurrentController.Select(oCellRange)
'Insert the result variable result into the selected cell.
ThisComponent.CurrentSelection.FormulaLocal = dateModified
End Sub
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
