Hide / unhide rows with help of a checkbox

**Hansa** · 03-07-2009, 02:24 PM

Hello,

I need your help, i'm just not good enough

I need to hide / unhide some rows in a sheet with the help of a activex checkbox... I want remove, let's say row 20:24 and row 34 with one checkbox. Can somebody please help me out.

Thanks a lot

Cheers

**Leith Ross** · 03-07-2009, 02:50 PM

Hello Hansa,

Welcome to the Forum!

Here is the code for the CheckBox. Just be sure to change the CheckBox name to match the name of your CheckBox.

Please Login or Register  to view this content.

**JBeaucaire** · 03-07-2009, 03:04 PM

A little trick I learned from Mike Rickson, if the test you're doing is a TRUE/FALSE test, you can just match the test to the condition in a single row, like so:

Please Login or Register  to view this content.

Or even all the way down to:

Please Login or Register  to view this content.

**Hansa** · 03-08-2009, 07:13 PM

Hello,

thank you both for the warm welcome and help, now everything is working like a dream

**JBeaucaire** · 03-08-2009, 07:24 PM

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

**mudraker** · 03-08-2009, 07:47 PM

Just to clarify JBeaucaire last reply

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**Hansa** · 04-03-2009, 12:56 PM

Hello,

I have not been logged in for a while, and therfore I have not marked my thread as solved.... sorry. Could somebody be so kind and mark it as solved for me.

Thank you