Hello,
In a workbook where a lot of people enter information, I'm looking for a way to see who filled in which cell.
My sheet is protected, only cell C2+D2, C3+D3, ... have to be filled in.
In cell E2, E3, .... I want to see the user who made the changes with VBA retrieving the username.
Can anybody help me?
Last edited by dries_v; 08-06-2014 at 08:29 AM.
Environ("Username") or Application.Username
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Thank you for this.Originally Posted by nathansav
Since I am a beginning user, I followed your signature suggestions and looked some stuff op on google etc.
I created this code:
This works fine, except, when I change the original value in eg H6, it starts filling username en date-time in offset next to the previous username en date-time.
Please Login or Register to view this content.
I assume the wrong part of the code is "End(xltoleft)". With what should I replace?
Was able to solve it myself using this code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks