First forum post - been searching this issue for a couple of hours and can't seem to find anything.

I am creating a form using Excel 2010 that is meant to look nice and function well. I have grouped rows (36:39) so that users can toggle their visibility.
If the user hides those rows, I would like to keep all the content beneath those rows from shifting up. I want everything else to stay in the same place, but have the rows appear as if they are turning invisible when toggled. My idea to do this was to have the same number of rows (40:43) have an inverse visibility relationship with 36:39 - you hide 36:39 by clicking the group toggle and 40:43 automatically unhide, and if you expand 36:39, 40:43 hide.

I am a fairly new VBA user, just learning, so if anyone is kind enough to post code, please include everything that will be needed.
Thank you!