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

 

[1q2w3]

Thanks!

 

[mumps]

You are very welcome.