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.

If FlexSerSubvBx.Value = True Then
Rows("39:40").EntireRow.Hidden = False
End If

If FlexSerSubvBx.Value = False Then
Rows("39:40").EntireRow.Hidden = True
End If

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.