hide and unhide rows in different worksheet using a checkbox

Hi there,

I am trying to use a check box in sheet1 to hide and unhide the rows (3:7) in sheet2

So if the check box in 'sheet1' is true (ticked), then the rows in sheet2 to bbe hidden automatically and vice versa.

I have attached the sample excel file below.

Any help will be highly appreciated.

Cheers,

Put a macro like this:

Please Login or Register  to view this content.

in a module and assign it to the check box (right click on check box and choose "assign macro")

or

Please Login or Register  to view this content.

Thank you All!!! It works perfectly.