first record a macro that hide what you want, the put excel in design mode
ans right click on the cb1, in the menu shown click on assign macro and
assign the macro that you previusly record.

"Qaspec" wrote:

if a checkbox ("cb1") on sheet1 is clicked i would like to hide rows 5
through 10 on sheet 1 and hide row 4 on sheet2. thanks.