ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   tracking changes and showing usernames (https://www.excelbanter.com/excel-worksheet-functions/123044-tracking-changes-showing-usernames.html)

Jim

tracking changes and showing usernames
 
In excel I know there is a function for tracking changes - however, when the
users go to view the changes and more specifically the "who" field on those
changes it does one of three things. It shows Administrator (if the user in
question has admin priveledges to the domain), The distribution group all the
users belong to or the field is left blank.
I've made sure that the individuals have folder/file access (not the
distribution group).
Any thoughts on what might be going on here?

plb2862

tracking changes and showing usernames
 
"Jim" wrote in message
...
In excel I know there is a function for tracking changes - however, when
the
users go to view the changes and more specifically the "who" field on
those
changes it does one of three things. It shows Administrator (if the user
in
question has admin priveledges to the domain), The distribution group all
the
users belong to or the field is left blank.
I've made sure that the individuals have folder/file access (not the
distribution group).
Any thoughts on what might be going on here?


Have you tried a VBA to get the logged-in username as well as a VBA to get
the change information?

http://www.ozgrid.com/VBA/track-changes.htm

get logged in user name.
http://blogs.officezealot.com/charle...2/10/3574.aspx




All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com