Jim,
Here's the UDF:

Function lastsaved() As Double
lastsaved = ActiveWorkbook.BuiltinDocumentProperties(12)
End Function

Thanks again
Joe M.



"Jim May" wrote:

Joe Post the UDF code

"Joe M." wrote:

I have a worksheet with a UDF that displays the last saved date. There are
other cells which have dependancies on this date. When saving and reopening
the document the date remains unchanged. I have tried F9, Shift + F9, CTRL +
ALT + F9, CTRL + SHIFT + ALT + F9 and also changing the settings in OPTIONS
CALCULATION from automatic to manual back to automatic. Recalculate before
save is checked. When I close the workbook and reopen the date remains the
same. If I retype the formula in another cell then the date displays
correctly. Can anyone help?

Much appreciated!
Joe M.