I have a check box in sheet 1 called "Travel" which hides rows 30:31 as below:
Private Sub CheckBox6_Click() [30:31].EntireRow.Hidden = Not CheckBox6.Value End Sub
I also want to hide row 3 and rows 13:21 of another sheet within the same spreadsheet called "Look up" when this same check box is selected.
Does anyone know the code for this?
Thank you
Aucun commentaire:
Enregistrer un commentaire