| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA code
Hi all
Thanks for previous help.It was very helpfull. Now again I need a code to display group of sheets and activate one of them and hide other sheets rather than group displayed . Many thanks if anybody can help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA code
Paste the procedure "DisplayWorksheet" and call that from the command button
click event like below example DisplayWorksheet ("Sheet1") Sub DisplayWorksheet(strSheet As String) 'This will hide all other sheets except "Summary" and display strSheet Application.ScreenUpdating = False For Each wstemp In ActiveWorkbook.Sheets If wstemp.Name < "Summary" Then wstemp.Visible = False Next ActiveWorkbook.Sheets(strSheet).Visible = True Application.ScreenUpdating = True End Sub -- If this post helps click Yes --------------- Jacob Skaria "NIDAL" wrote: Hi all Thanks for previous help.It was very helpfull. Now again I need a code to display group of sheets and activate one of them and hide other sheets rather than group displayed . Many thanks if anybody can help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code does | Excel Programming | |||
| Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
Linear Mode
