I would like to hide 10 rows on my worksheet unless a tick box is selected is this possible.
lesley burlingham Member Nov 24, 2014 #1 I would like to hide 10 rows on my worksheet unless a tick box is selected is this possible.
N NARAYANK991 Excel Ninja Nov 24, 2014 #2 Hi Lesley , Yes. Please upload a sample workbook with the checkbox in it. Specify the rows you want hidden. Narayan
Hi Lesley , Yes. Please upload a sample workbook with the checkbox in it. Specify the rows you want hidden. Narayan
lesley burlingham Member Nov 25, 2014 #3 Check box is on row 79. I would like to hide rows 80 -89 when the box is ticked. Thanks
N NARAYANK991 Excel Ninja Nov 25, 2014 #4 Hi , See the uploaded file. There is an ActiveX checkbox , as well as an MSForms checkbox. Both of them will hide and unhide the 10 rows from rows 80 through 89. Narayan Attachments Hide_Unhide_Rows.xlsm 20.4 KB · Views: 9
Hi , See the uploaded file. There is an ActiveX checkbox , as well as an MSForms checkbox. Both of them will hide and unhide the 10 rows from rows 80 through 89. Narayan
lesley burlingham Member Nov 25, 2014 #5 This is amazing thank you. If i wanted to hide row 74 in sheet 1 when C54 in sheet 2 = yes how would i do this.
This is amazing thank you. If i wanted to hide row 74 in sheet 1 when C54 in sheet 2 = yes how would i do this.
N NARAYANK991 Excel Ninja Nov 25, 2014 #6 Hi , See the file. Narayan Attachments Hide_Unhide_Rows.xlsm 22.7 KB · Views: 7