Gronk_h8er
Board Regular
- Joined
- Jan 6, 2009
- Messages
- 63
Hi all,
I need help in putting together a macro that collapses groups across all of my worksheets.
I know the VBA to collapse the groups in the active worksheet
Code
ActiveSheet.Outline.ShowLevels RowLevels:=1
/Code
But i don't know how to write a macro that will go to each worksheet in my workbook and collapse the groups.
Assume the worksheets are called 'sheet1', 'sheet2' etc.
Any help would be greatly appreciated!
Regards,
Thomas
I need help in putting together a macro that collapses groups across all of my worksheets.
I know the VBA to collapse the groups in the active worksheet
Code
ActiveSheet.Outline.ShowLevels RowLevels:=1
/Code
But i don't know how to write a macro that will go to each worksheet in my workbook and collapse the groups.
Assume the worksheets are called 'sheet1', 'sheet2' etc.
Any help would be greatly appreciated!
Regards,
Thomas