Desplay active and Hide sheets
 

Thanks for help
Suppose I have Workbook contain 10 sheets and one of them is summary.
What I need exactly to Create 3 buttons In Summary and each button display
3sheets as group and activate one of them I chose it ,and finally Hide othe 6
remaining sheets, all of this by one click a button.
by the same way,the oter button will display next 3 sheets, activate
specified one, and Hide other, and so on.

many thanks

Desplay active and Hide sheets
 

Nidal,

You can use a command similar to the following to group the sheets:

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select


--
Regards,
Eddie
http://www.HelpExcel.com


"NIDAL" wrote:

Thanks for help
Suppose I have Workbook contain 10 sheets and one of them is summary.
What I need exactly to Create 3 buttons In Summary and each button display
3sheets as group and activate one of them I chose it ,and finally Hide othe 6
remaining sheets, all of this by one click a button.
by the same way,the oter button will display next 3 sheets, activate
specified one, and Hide other, and so on.

many thanks