One way would be to place a brief string about who saved the file and
when into a specific cell on a sheet. This code uses the BeforeSave
event of the workbook to achieve this (mind the text wrapping) :

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

ThisWorkbook.Sheets(1).Range("A1").Value = "Last saved at " & Time & "
" & Date & _
" By " & Application.UserName

End Sub

This places the time, date and Excel username into cell A1 of the first
sheet, such as "Last saved at 00:04:30 22/07/2006 By Jakey C"


bsnapool wrote:

Is there anyway I would be able to know when a worksheet has been
updated by using a macro?

I have 73 files within a folder which are either updated from Monday -
Wednesday (Or sometimes not even updated) by managers.

Is there anyway I could automatically find out whether the files have
been updated and maybe the date of when it was last saved?

Hope this is all the info you may need.

Many thanks

Andrew


--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile: http://www.excelforum.com/member.php...o&userid=36115
View this thread: http://www.excelforum.com/showthread...hreadid=563912