The spreadsheet is very detailed with many product lines, each with their own product families and products listed underneath
When a user selects a product line from a list, a vb macro fires off to hide all other non product lines selected,
by hiding all and then unhiding the selected product line rows.

However, I want the grouping box for each product family to remain closed so that the user only opens
the desired product family product list by ungrouping the product family desired. Makes for an easy way to
keep the focus of the user without all the other spreadsheet information distraction.

auto record macro doesn't see the grouping boxes open or closing, in Excel 2007.

any suggestions?

thanks in advance,