Hold down ALT and hit F11. Insert a new Module and pase the following code
into it:-
Public Function LastModified()
LastModified = Format(FileDateTime(ThisWorkbook.FullName), "dd/mm/yy hh:nn")
End Function
On you spreadsheet click in the cell you want the date to appear and type
the following into the formula bar:-
=LastModified()
That should just about do it.
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk
If I have solved your problem, please click Yes below. Thanks.
"Eán" wrote:
Is there a way like in Word I can have a cell in excel which will show the
date the worksheet was last updated?
Please and thank you.