| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharing workbook, show last user change?
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?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sharing workbook, show last user change?
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) -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=548117 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing workbooks - user access | Excel Discussion (Misc queries) | |||
| Macro broken with workbook name change | Excel Discussion (Misc queries) | |||
| Prevent user from saving workbook | Excel Discussion (Misc queries) | |||
| Inheriting a laptop--how do I change office user account informati | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
