I am trying to create a workbook that will be shared by more than one user.
I also have posted this same request for help on crossposted: http://www.ozgrid.com/forum/showthread.php?t=198132
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 select info. from 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 are not 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.
Bookmarks