formula to display "updated" date

[cindi]

Is there a way to have a cell display the date that a
worksheet was updated (not just merely opened or printed,
but actually updated, in someway)?

Thanks,

Cindi

 

[Peo Sjoblom]

See:

http://tinyurl.com/5xu86


Regards,

Peo Sjoblom

 

[cindi]

what does this mean? What is a UDF and how do I get
there?

Sorry for my ignorance.

Cindi

 

[Gord Dibben]

cindi

A UDF is a User Defined Function. Similar to Excel's built-in Functions but
written because Excel does not have that particular Function.

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + R to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Code to paste into the module............

Function DocProps(prop As String)
application.volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function


In a cell enter =DOCPROPS("last save time")


Gord Dibben Excel MVP