Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Last Editor's Name
I have a spreadsheet that is going to become a shared everchanging document. I have already turn on the track changes history, but I would also like to be able to display the name of the person who last edits the document on the front page of the document. How can I accomplish this easily? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Last Editor's Name
Jenni,
Worksheets("Sheet1").Range("A1") = Application.Username will give you the UserName in a cell (modify the loaction to suit). Problem is where you fire it from. If done in the Workbook_BeforeSave Event, it'll update whenever a user actually saves the workbook. In the Workbook_SheetCalculate Event, it'll update whenever someone makes a change that would cause the workbook to calculate. There are a number of other events you could place this code in depending on what you want it to update on. John Jenni Anderson wrote: I have a spreadsheet that is going to become a shared everchanging document. I have already turn on the track changes history, but I would also like to be able to display the name of the person who last edits the document on the front page of the document. How can I accomplish this easily? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
displaying changes | Excel Worksheet Functions | |||
Displaying a zero | Excel Discussion (Misc queries) | |||
Not displaying a value | Excel Discussion (Misc queries) | |||
Displaying a different value | Excel Discussion (Misc queries) | |||
Displaying #N/A as a zero | Excel Worksheet Functions |