Hi
I have a macro (below) that records an audit trail and it works well. However I use a shared workbook with 2 other users and when the workbook is saved only 1 persons audit log can be saved as the others are wiped over. Therefore i wanted the logs to be in seperate locations. Person A, data input from column 1 in "log" (as macro below) Person B, data input from column 8 and Person C, data input from column 15 all in "log" worksheet. When I try to write in that when If application.username="person A" then do a and If application.username="person B" then do B (another macro with "Cells(65000,8)"), the macro doesn't work. Any help would be appreciated.
Bookmarks