Expand and Collapse Grouping Code

[Dulanic]

Hello,

I have a macro setup to protect and unprotect all sheets in a workbook. I have half of this working... This portion locks all of the sheets with a specified password, and they must know the password to do so. This locks all sheets and collapses the groupings as it should.

Please Login or Register  to view this content.

However, This code which is for unlocking the sheets, I want it to expand all groupings.... it is not doing so as I thought it would.

Please Login or Register  to view this content.

Where am I going wrong with the ungrouping? I would think it should work much as the grouping portion does correctly.

[Dulanic]

Well I feel stupid....All Set!

Please Login or Register  to view this content.