UserName to deterine list in ComboBox, Password Protecting linked Cell

[ron2k_1]

I've been working on something like the attached for days (see rough sample attached). It's still a bit buggy, and I would really appreciate if the professional can take few mins to look over and recommend changes.

I've found the following issues (Note that you may have to edit the code in "ThisWB" to include your username to have a list do display on the combobox):

1. I want users to restrict themselves to use the combobox. Therefore, I've added a piece of code to password protect the ws if B1 is selected. However, when I select something after locking, it still tells me that the ws is locked even after adding code to unprotect it
2. If you close the WB and go back into "Comparison Summ" and make a selection on the combobox, it'll will tell you that is locked, blah, blah, blah, and then if you try to print preview, my excel crashes

Point #1 is really nagging, as you will have to select twice in order for the value to appear on B1, as the first selection it'll tell that the sheet is locked for editing. Bear in mind that the original sheet has tons of formulas referring to B1.

Referencing to another cell, and locking the sheet is currently not an option as there is other code that refer to ranges on that sheet, and there are hundreds of INDIRECT formulas, so adding a row or column would mean to change all the code and formulas. I prefer to contemplate that later if debugging the above is not possible.

I apologize for my faults in the above code and want to thank you in advance if you can provide help.

Thanks

Ron