Hi,
I'm working on a worksheet where I have a series of checkboxes in the same column and consecutive rows. The goal is that a checkbox (if UNCHECKED) will hide a single SPECIFIC row in a separate worksheet. I'm not sure how to accomplish this, but I have seen a lot of blogs concerning macros. Below is the specific cell information and how it would work out. Any advice on using macros and the appropriate code would be appreciated. Thank you!
Checkbox1 located on 'sheet1' B8
Checkbox1 linked to 'sheet1'G8
If unchecked or 'FALSE', I want to Hide 'sheet2' Row 14
It needs to be easily repetitive, ex:
Checkbox1 'sheet1' B8 = false, then hide 'sheet2' row 14
Checkbox2 'sheet1' B9 = false, then hide 'sheet2' row 15
Checkbox3 'sheet1' B10 = false, then hide 'sheet2' row 16
etc... through roughly 200 check boxes.
Help? :-(
Thank you!
I'm working on a worksheet where I have a series of checkboxes in the same column and consecutive rows. The goal is that a checkbox (if UNCHECKED) will hide a single SPECIFIC row in a separate worksheet. I'm not sure how to accomplish this, but I have seen a lot of blogs concerning macros. Below is the specific cell information and how it would work out. Any advice on using macros and the appropriate code would be appreciated. Thank you!
Checkbox1 located on 'sheet1' B8
Checkbox1 linked to 'sheet1'G8
If unchecked or 'FALSE', I want to Hide 'sheet2' Row 14
It needs to be easily repetitive, ex:
Checkbox1 'sheet1' B8 = false, then hide 'sheet2' row 14
Checkbox2 'sheet1' B9 = false, then hide 'sheet2' row 15
Checkbox3 'sheet1' B10 = false, then hide 'sheet2' row 16
etc... through roughly 200 check boxes.
Help? :-(
Thank you!