Simple macro to group rows for a form

Hello!

This is my first post, and I'm hoping to get some VBA help for a simple macro I wish to run (I have very little knowledge of macros).

I am creating a new form, and have 2 option boxes. I have linked these checkboxes to a cell which gives a calculation depending on what is selected (cell E10). If the value of this cell is 2, then the person has selected that they don't need to fill in the details below. If this is the case then I would like to hid the entire rows below (rows 18 - 45 to be precise).

At the moment I have used data validation to blank out these rows, but I'd much rather group them automatically to avoid a large gap between the option boxes and the next section. Is there a simple way to do this?

Please let me know if I need to provide more information, or if I need to attach a copy of the spreadsheet (I'm not sure how this works).

Thanks!

Hi Martin,

Thanks for the quick reply. I tried your solution above (using E10) and it did work, but when I test the option boxes it comes up with this error message:

Run-time error '1004':

Unable to get the RowHeight property of the Range class

I'm not sure how to solve this problem?

Hi Martin,

I've attached the form.

Thanks for any help you can give!

This is great. I just amended the cell reference to E10, and it worked a treat.

Thanks!

Hi again,

Sorry but I forgot to mention, I need the spreadsheet to be protected when the macro is run (at the moment it comes up with 'run-time error 1004). Is there a way to make the macro run in password-protected spreadsheets? Perhaps an adjustment to the script?

Thanks