I guess I don't understand. I have unlocked the linked cells them protected the work sheet. Message saying work sheet protected persist, telling me to unlock work sheet. My goal is to update data by using the pull down box but not allow typing on the work sheet it self.
Again
Thanks for the help........
What kind of combobox are you using ?
* Data Validation ?
* Forms toolbar ?
* Control toolbar ?
What version of Excel are you using ?
Juan Pablo G.
I am working in Excel 2000 using the From Toolbar.
I did this.
Created a new book, and all the cells, by default, are locked. Now, inserted a Form ComboBox, linked it to B1, and used A1:A3 as Data Range. (Sheet is still unprotected).
It works.
Now, I protected it, and I get an error (Because B1 is locked). I unprotect again, select B1, went to Cell Format, Protection, and unchecked "Locked", and then reprotected the sheet.
The combobox works now, with the sheet protected. So, one of us is doing something wrong here...
Juan Pablo G.
Your right, one of us is doing something wrong and I bet anything it's me. Thanks for the help so far. I am going to reread your answer and keep trying till I get it right......LOL
Just make sure that you're really unlocking the "data" cells that link to the controls, that's something I always forget.
Juan Pablo G.
Juan,
You were correct, I was over looking a linked cell which was locked. Thank you for all the help.
Denny