Excel vba code for multi user logins and passwords

  • I am trying to create a workbook that will be shared by more than one user.

    In this workbook each user will be able to update and edit certian cells within this workbook (Cells B12:I24).

    This workbook will have many different tabs and for each tab I only want each user to be able to update or change information on cells B12:I24. These cells will be drop down lists that the users can choose information to complete the form.

    I would like for each user to have their own user login and user password.

    If possible I would like to be able to keep a record of each user login date, time and changes.

    I would like to protect the workbook so that reamining cells the users will not be able to change the information. Also no one else can access the workbook if they do not have the right credintals.

    I have researched the web for this item and have tried many different suggestions but keep having problems.

    Any help would be greatly appreciated.

    I have attached the workbook as an example.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!