modified date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top