Hi guys I have two worksheets - "Comparison Detail", and "Comparison Summ"
On "Comparison Detail", I have:
And on Comparison Summ:
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
Bookmarks