Cannot use VBA check box with protected sheet/columns

Hi,

I need to make a excel costing model to calculate various products prices. I am using Excel 2010.

I have many products and do not need all of them displaying at the same time, therefor I inserted a Checkbox (ActiveX Control) that hides my columns that I do not need.

I did that by inserting the following and it works fine :

Please Login or Register  to view this content.

The problem is I now need to lock certain cells so that they can remain fixed and the recipe cannot change.

Once locked my checkbox no longer works and I get the following error : "Run-time error '1004': Unable to set hidden property of the range class"

Can someone please help and tell me how this can be done? fyi the above is all I have done on VBA, so limited knowledge on VBA.

Thanks