Harvey

You could use some workbook_Sheetchange event code like so (This code goes in the ThisWorkbook module)

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.EnableEvents = False
Range("A1").Value = Now()
Application.EnableEvents = True
End Sub

This will place the date and time on each worksheet in a workbook in which it is placed in A1 of the sheet changed

You could also switch on the track changes feature which writes to a hidden sheet and has much more detail than this

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Harvey Gersin" wrote in message ...
Several people need access to particular Excel Spreadsheets on a company server. Every time they open a sheet, we need to know the date and time that sheet was last accessed.

Is there a way to have the date and time register automatically when a sheet is opened or when information is placed in any cell within the sheet?

Help is appreciated.

--
___________________
Harvey Gersin