Run-time error 1004; "Unable to set the Hidden property of the Range Class"

I am new to excel programming so I apologize for any misuse of terms, terrible programming, and all around poor form!

I am trying to protect a spreadsheet that I created that uses VBA to run some code. Everything works fine until I protected the sheet (minus the fields that I want users to fill in). Some details: the VBA is set up to detect when the word "hide" pops up in a specific field. "Hide" will turn on and off depending on the data the user enters to the unlocked fields and that entire row will then hide or unhide. My sheet has combo boxes (8 in total) that users use to enter data from a long list of options, and there are merged cells.

What other information will be helpful in troubleshooting? Thanks so much for any input.

Here is the code that I am using:

Please Login or Register  to view this content.

JapanDave - thanks for the reply, however I am getting the exact same issue. When I click on debug, "cel.EntireRow.Hidden = False" is highlighted. This was the case for my original code and yours as well.

Any other ideas?

JosephP - that worked great! I entered the following code in the "ThisWorkbook" workbook object. Still testing but haven't found any errors as of yet.

(password modified of course

Please Login or Register  to view this content.