Sharing workbook, show last user change?

P

paul89

I share a workbook with others in the office, i'd like to create a cell that
shows who the last user was that saved something, and the date/time it was
saved. Is this possible??
 
M

mrice

Sounds like you need a macro linked to the Before_Save event.

You can get the date from the Date() function. Getting the user can be
done with ActiveWorkbook.UserStatus(1,1)
 
Top