Capture user name when a new row is inserted in Excel 2003 workbook
Posted on 2010-01-11
Searching previous posts, I found the following code to capture user name in Excel spreadsheet :
Function LastAuthor() As Variant
LastAuthor = ActiveWorkbook.BuiltinDocumentProperties(7)
And it works great for changes to existing rows, but I need to capture the user name who inserts new rows into the spreadsheet. How do I go about that?