Can it be done?! Thanks for all of the tips in the discussion group- I have
learned how to create collapsible rows. Now I'm wondering if I could have a
command button that would automatically expand and collapse the rows. I'd
appreciate your assistance in explaining what that code would look like.
Thanks!

As ALWAYS, post what you have already done for comments

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stephanie" wrote in message
...
Can it be done?! Thanks for all of the tips in the discussion group- I
have
learned how to create collapsible rows. Now I'm wondering if I could have
a
command button that would automatically expand and collapse the rows. I'd
appreciate your assistance in explaining what that code would look like.
Thanks!

Do you mean
ActiveSheet.Outline.ShowLevels RowLevels:=1

ActiveSheet.Outline.ShowLevels RowLevels:=<max number of levels

If this post helps click Yes
---------------
Jacob Skaria


"Stephanie" wrote:

Can it be done?! Thanks for all of the tips in the discussion group- I have
learned how to create collapsible rows. Now I'm wondering if I could have a
command button that would automatically expand and collapse the rows. I'd
appreciate your assistance in explaining what that code would look like.
Thanks!