Protect/unprotect certain cells with macro

[1q2w3]

Hi all,

I need help with protecting certain cells within my worksheet to prevent cells from being edited.

I have an excel sheet that have a drop down list, it hides certain rows based on the selection. I used macros to set this up and these are working fine at the moment.

I have Column C and D that I want user to be able to edit, but E and F not.

I've tried using the protect sheet method but I am getting a run time error code 1004 - unable to set the hidden property of the range class.

Please can someone help?

Thanks

 

[Fluff]

Duplicate Macro

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).