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.