E Eán Dec 23, 2008 #1 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.
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.
L Luke M Dec 23, 2008 #2 See this previous post with a similar question http://www.microsoft.com/office/com...&p=1&tid=51be9c02-b847-414c-9dee-29c3bb4e1fdf
See this previous post with a similar question http://www.microsoft.com/office/com...&p=1&tid=51be9c02-b847-414c-9dee-29c3bb4e1fdf
A Alan Moseley Dec 23, 2008 #3 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.
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.
