need help with an auto hide/unhide row macro

[jroyse]

Hi all,

I have a macro written that auto hides/unhides certain rows on certain sheets in my workbook based on a value in another cell on the "cover page" that is derived from a formula. This value changes based upon values of other cells. The particular values for this cell are "Small Scope", "Medium Scope", & "Full Development" as you will see in my macro below. My specific rows will auto hide/unhide based on those 3 values.

The macro works great, however, the the rows that it hides/unhides are grouped rows and when it unhides the rows, they all expand. Is there a way to achieve the same result and keep my rows collapsed once unhidden?

I'll put the macro and some screen shots of what im asking.

This is what I would like. All of the grouped rows collapsed.
Stage gate want.png

However, this is what it does when rows are unhidden. It expands all of the rows.
Stage gate dont want.PNG

Below is my macro. any help is appreciated. thanks in advance.

Please Login or Register  to view this content.

[skywriter]

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[jroyse]

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Skywriter,

I appreciate you taking the time to look at and respond to my post. If there is a next time however, could you practice a little more tact when responding to forum members? There is no reason to be brash and harsh to a member reaching out to his community for some assistance. If my code and pics(if you can see them), coupled with my description are not enough information, please just ask for more info. Or simply ask me to upload a sample file or the file in particular so that you can practice different coding scenarios if you do not know the answer off of the top of your head. I do not expect anyone to "Re-type" my data and will gladly upload a sample file if need be but my code is fairly simple. These rows hide when this cell has this value. Simple enough. However, these are grouped rows and when they unhide, all of the grouped rows expand whereas I need them to stay collapsed. If at all possible. Thank you and I will upload a file at a later date.

[jroyse]

Sorry for my tardiness in uploading the file. Been crazy busy at work. Here is a sample file with the macro working. Once again, I would like to find out if I can make the rows stay collapsed when unhidden. Thanks for the support.