Drop Down control fails when sheet is protected

I have a worksheet where I've used a drop down control. Based on the selection, the associated code copies data from one set of cells to another. I've used unprotect and protect code at the beginning and end yet when selecting options from the drop down I get the -sheet is protected- error. Code is below if anyone can determine what is wrong here. I've used this same protect and unprotect on other worksheets without this kind of problem.

I've made sure that the control is not locked, I've even unlocked the cells where the control data is located and neither of these options work.

Please Login or Register  to view this content.

What I have found is that when I set up the controls, I also configured "Cell link". It's this cell that is locked and it appears that the control attempts to change the linked cell before the vba code is allowed to run (which would unlock all the cells) and this is causing the error. Rather than unlock this cell on the worksheet with the control (so that users don't tab over to it when using the worksheet), I configured the link to point to another worksheet that is unlocked and hidden.

Problem solved!