modified date:Can i set up a sheet

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" <[email protected]> wrote in message
news:[email protected]...
> 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