| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide rows of active selection | Excel Programming | |||
| hide non active sheets in workbook | Excel Programming | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| How to hide a column once any cell of that col. is not active any | Excel Programming | |||
| Desplay zero if yes | Excel Worksheet Functions | |||
Linear Mode
