Sharing workbook, show last user change?

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

Guest

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??
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sharing workbooks limitations - Merged Cells 12
Last Modified By in a cell by user 3
Shared Workbook is "in use by another user" 3
Displaying when workbook was last updated 4
When sharing, can I force an Excel document to open in a certain view? 0
corrupted shared excel workbook 1
shared workbook - shared workbook options grayed out 0
The Sheet-Rename feature is greyed-out in my Excel 2003 workbook.. 1

Back
Top