When I enter =lastsaved() in a cell the cell shows #NAME?
I changed the format for the cell to date?
Sorry to be such a beginner

"Gary''s Student" wrote:


Macros are very easy to install and use:

1. CNTRL-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff (three line function) in and close the VBE window

If you save the workbook, the macro will be saved with it.


To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

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




--
Gary''s Student
gsnu200705


"debbieevans" wrote:

Do I copy the 3 lines below into the sheets code? or do I have to add some
text, sorry but I am new to VBA?

"Gary''s Student" wrote:

If someone suggests a solution without VBA, ignore this response.

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

just enter:
=lastsaved()
in any cell.
--
Gary''s Student
gsnu200705


"debbieevans" wrote:

Is there a way to display last date modified on a worksheet without running a
macro and always in the same cell?