How to hide/unhide certain cells using checkbox

[kares]

Hi, I'm trying to find a macro code to hide/unhide certain/selected cells only using the checkbox. For example, if I tick the checkbox, it will show cells "A4:D9" but when I unchecked it, the mentioned cells will be hidden.

Attached is a sample of my query. The shaded parts are the ones supposed to hide/unhide.

Thanks a lot!

 

[Peter_SSs]

Welcome to the MrExcel board!

You cannot hide just 24 cells. If you want those cells hidden then you must either ...

1. Hide all of rows 4:9, or
2. Hide all of columns A:D

Which do you want?

 

[kares]

Welcome to the MrExcel board!

You cannot hide just 24 cells. If you want those cells hidden then you must either ...

1. Hide all of rows 4:9, or
2. Hide all of columns A:D

Which do you want?

oh, I see. It would be nice if I could hide/unhide certain cells but if that isn't possible, that's okay. I already opted to hide the rows instead. Thanks by the way.

 

[Peter_SSs]

You're welcome. Sorry I couldn't do what you wanted.

Rather than physically hide the actual cells, would an option be to mask whatever is in those cells by making the text and background cell colour the same?
.. or the checkbox code could cover/uncover the cells with a solid colour rectangle?