I've been searching forums and trying codes for days and cannot solve this problem. PLEASE HELP! I'm in a bit of a time crunch.
Unfortunately I cannot post an example because it's confidential data.
On a sheet titled "Criteria Checklist," there are several checkboxes linked to cells that return a 1 or 0 when checked/unchecked.
On a sheet titled "Checklist Results," I have 3 rows I need to hide/unhide; these are rows 53-55. I have A53, A54, and A55 set equal to the checkbox formulas (0 or 1) on the Critera Checklist sheet.
If any of these rows is a 0 (i.e. the box on "Critera Checklist" was unchecked), I want that specific row to be automatically hidden. (I.e., if column A for Rows 53 thru 55 reads 0, 1, 0, I want rows 53 and 55 to hide.) But I want this all to run AUTOMATICALLY...So the hiding/unhiding will toggle right along with the checking/unchecking of the boxes.
To add to the complication, if all 3 rows = 0 (all boxes are unchecked), I also want to hide row 52.
Please help! And I'm a newbie to VBA so please specify where/how I need to paste in the code. Thank you!!!!
Bookmarks