Unhiding / Hiding rows based on a different cell value

Originally Posted by gm2612

Dear Winon, I am using the check box from "Forms" menu. Which one you recommend to use?

I find Form-type checkboxes easy to work with. Easier than ActiveX in some cases. Especially if you have several checkboxes that do nearly the same thing. It may be possible to have one procedure for all the Form-type checkboxes. ActiveX checkboxes require each have an event procedure.

Maybe assign this this to your Form-type checkbox.

Sub Toggle_Rows
      Rows("13:15").Hidden = Not Range("H11").Value
End Sub