Hi guys I have two worksheets - "Comparison Detail", and "Comparison Summ"

On "Comparison Detail", I have:
Please Login or Register  to view this content.
And on Comparison Summ:
Please Login or Register  to view this content.
Both Comboboxes refer to B1 of its corresponding worksheet. And I need Combobox, because its list depends on the Environ$("USERNAME") case.

I need B1 to be protected because, the user can just type in a value in there that may not be allowed and the worksheet may generate date that he/she is not allowed to view.

However, everytime I try to change the combobox, I think because of its interdependency between the two pages, it is not unprotecting properly as it tells me that the cell I'm trying to change is read-only

Any ideas?

Ron