Unhide Columns-Rows from a workbook

**donk04** · 03-20-2015, 03:56 AM

Hi to everyone.

I have a workbook which include about 30 sheets. There is anyway with the help of a macro to select all sheets, unhide any hidden rows and columns and the ungroup all sheets?

Thanks in advance for your valuable time.

**JOHN H. DAVIS** · 03-20-2015, 09:42 AM

Maybe:

Please Login or Register  to view this content.

**donk04** · 03-20-2015, 10:40 AM

It works fine.
Many many thanks for your valuable time and help.

**JOHN H. DAVIS** · 03-20-2015, 11:28 AM

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rules and mark this thread as solved. Refer to link below for guidance.

http://www.excelforum.com/forum-rule...rum-rules.html