Hide Check Box if Row is Hidden

CMAnderson

New Member
Joined
Jan 11, 2019
Messages
6
Cell D13 is blank when the worksheet opens up.
Once(if) the end user enters a number into cell D13 that is greater than 1, row 14 appears.
in Row 14, i have prompted the user to check yes or no to an option, both yes and no have check boxes.

the issue i am running into at this point is that when Row 14 is supposed to to hide, the check boxes are not hiding with the row.
i have tried adjusting the properties but nothing seems to help hide these check boxes.

is there a way to fix this?

2uA8ycsvEYTL5IvMpbWV7mMBm0RSrbYLXBG4kZcjAF4lb9PyY9IAh7P05yAAAAAElFTkSuQmCC
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Checkboxes are on the drawing layer of the worksheet. An alternative is Marlett checkboxes, which are are part of the data layer. They are simple to mechanize, and the forum has hundreds of examples.
 
Upvote 0

Forum statistics

Threads
1,224,763
Messages
6,180,825
Members
452,997
Latest member
gimamabe71

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top