Show/Hide Sheet 2 based on checkbox located on Sheet 1

i have a workbook with multiple sheets. I would like to only show sheets 2-10 if a corresponding checkbox is checked on sheet 1. i know this can be done, I'm just not sure exactly how. any help will be appreciated

Use an ActiveX checkbox not a FormControl checkbox. I am assuming that the name of the checkbox is CheckBox1 and that you specifically meant sheets 2-10 not the name 2 - 10.

Please Login or Register  to view this content.