track who makes changes in excel

If you're using this on a network you should find you can use

Please Login or Register  to view this content.

the above, unlike Application.Username, will be populated regardless -- and will reflect login credentials of network credentials -- e.g. JDoe

edit: I may have misinterpreted your requirement ... are you saying you have different people using a common login?

You would probably want to use the Workbook_Open event. From there, use a form or application.inputbox to gather the user info.

Save the attached file. Close it and then re-open it. You will be prompted to enter a name. This sample file has a list of users in column A of Sheet2. I just used the letters a, b, c and d for the names. You can enter the names of your 5 users. When prompted, enter one of the four letters. A time stamp will be entered beside the name on Sheet2 each time a user opens the file. This will tell you when any user opens a file. You can hide Sheet2 so that your users cannot see it or modify it.

Hey Mumps1,
Thank you for your reply.

This sample file works great.
However a user can easily manipulate while loggin in.
User "A" can enter his name as "B" and thus that would create confusion.

Is it not possible for the user to type a password along with their username?

Also,
Is it not possible to integrate the vba code of the file which you attached with mine? That way I would be able to track who makes what changes

Please Login or Register  to view this content.

Try the attached file. Again, save it, close it and then re-open it. I used the following names and corresponding passwords:

John a
Mary b
Jim c
Lucy d
Jane e

I tried the file you attached by making a few changes in some of your sheets and those changes were recorded properly on the Tracker sheet. When you say:

I am not able to see who makes what changes in sheet TRACKER

do you mean that the changes are not being recorded in Tracker or that the Tracker sheet is not visible?

The Tracker sheet and User sheet are hidden so that they cannot be seen or modified by your users. This will prevent them from seeing another user's password and changing the data ono the Tracker sheet. To view the sheets, you have to unhide them.

Do the following: Hold down the ALT key and press the F11 key. This will open the Visual Basic Editor. You will see all your sheets listed in the left hand window pane. Click the "Users" sheet to highlight it and then in the top menu, click "View" then click "Properties Window". At the bottom of the "Properties Window" you will see that the 'Visible' property is 'xlSheetVeryHidden'. Click on that property and change it to 'xlSheetVisible'. Repeat the process for the Tracker sheet. You then will be able to see the sheets. You can go back and change the 'Visible' property to hide them again if you wish. I would suggest that you keep them hidden for security reasons.

Sure Mumps1,

Thank you for yoour help.
I was able to get the tracker and user sheet successfully.
I would make it xlSheetveryhidden very soon.

However in sheet tracker , in users it shows "DELL".
Dell is my PC name.

Is it not possible to show the username of the person who logs in and makes changes?
By username I mean the credentials which we enter when we open the excel file. In this case it is John, ,,,,....

I have attached the workbook.
Please do have a look

If you mean the name the user enters when the file is opened, try the attached version of the file.

Hey Mumps,

This version of the file works perfectly...

Thank you.
THANK YOU SO MUCHHHHHH.


Also one small help needed.
In sheet PRODUCT , Range A:D - i type my product details. (item, weight, etc)
Is it possible to have the same username in column S of sheet PRODUCT as well when someone makes changes ?

Example: I make changes to cell B9 of sheet "PRODUCT" . Then i would basically want the username to appear in cell S9
or
I enter product details on cell A11, then it shows me the username in cell S11
Basically have the username of the person who makes changes to the row

Do you want the user name to appear in column S if you make changes only in column B or in columns A:D?

Try the attached file.

You are very welcome.

Try the attached file.

Try the attached. Instead of pressing ENTER, click on the OK button or press ENTER again when it moves to the OK button. This version will close the file if the password is wrong.

This is the only way I could get it to work that way.

My pleasure.