I have a project with Yes/No drop down boxes and depending on Yes, No, or clear, rows are hidden/unhidden using the If funtion. This has not worked correctly when the sheet has been protected, but unprotected it used to work. I've obtained help with other needs to this project, and now this doesnt work correctly unprotected either along with it still not working protected. Not to mention, depending on the situation, it's giving me errors.
My goal on this project is to cycle through Yes, No, and clear on all of the drop-down boxes and have the rows hidden/unhidden appropriately while the sheet is protected.
I currently only have the If funtion set to process the first few rows until this is resolved.
Attached is my Workbook (pw:123456) if someone has some time to check it out and assist. Thank you!
Bookmarks