View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NIDAL NIDAL is offline
external usenet poster
 
Posts: 6
Default 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