hide rows from checkbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide rows on different sheets 5
Excel Excel hide/ unhide row based on checkbox 0
Hyperlink to Same sheet but after that want to hide link sheet 1
My Never ending ARRAY code problems 18
Enable / Disable Buttons 2
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Hiding rows 8
Hidden Rows not working correctly 2

Back
Top