Hide rows in a protected sheet.

Hi Guys,

I have seen various ways to hide and un-hide rows in a protected sheet. So far none seem to be working for me. This is the line of code I am trying to get to work in a protected sheet.

Please Login or Register  to view this content.

So far I have attempted 3 different was to deactivate the password at the beginning of the code and then reactivate it at the end of the code. None have worked!!! Therefore I am starting to think there might be something else afoot. If anyone could help I would appreciate it. I have attached the document also and it is run in a userform named ClintInvShpInputForm.

Thanks in advance.

Hi gm4evr1, I forgot I'd set them to be hidden on opening. And yes your code is how I should of done it! Still learning. There is quite a bit of that in this workbook as I'm putting it together in a fractured way.. Thanks for the coaching.

Hi TMS, Thanks for this. The value is taken from column Q on 'Sheet1'. With FALSE/TRUE statements. I hadn't entered a value on this sheet by accident. Have done it now.