modified date
 

Can i set up a sheet within a workbook that will give the date and the
username of every person who modifies the spreadsheet.

THANKS

MONTY

Hi Monty,

You can use this code and put it in Workbook before close or Workbook before
save event:
ActiveSheet.Range("A1").Value = "Modified by: " & Environ("USERNAME") & ", "
& Date

Hope this helps.

--
Regards,
Peter Jausovec
(http://blog.jausovec.net)

"Monty" wrote in message
...
Can i set up a sheet within a workbook that will give the date and the
username of every person who modifies the spreadsheet.

THANKS

MONTY