mardi 3 novembre 2015

Hide rows in different worksheet when check box is selected

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