| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ungrouping sheet tabs with a Macro
Is there a VB code snippett that can ungroup grouped sheet tabs??
Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ungrouping sheet tabs with a Macro
There doesn't seem to be a specific ungroup command. Just selecting an individual sheet effectively ungroups the sheets: Sheets("Sheet1").Select |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Ungrouping sheet tabs with a Macro
I did try selecting one sheet and it does not ungroup unless I am holding
down the Ctrl button. "arjen van..." wrote: There doesn't seem to be a specific ungroup command. Just selecting an individual sheet effectively ungroups the sheets: Sheets("Sheet1").Select |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to protect sheet allowing grouping and ungrouping but alsoallowing changing colour of specific cells | Excel Discussion (Misc queries) | |||
| Macro that unhides sheet tabs | Excel Discussion (Misc queries) | |||
| Macro to name sheet tabs | Excel Discussion (Misc queries) | |||
| Allowing for Grouping and Ungrouping while Sheet is Protected | Excel Programming | |||
| Allow grouping / ungrouping while protecting the sheet | Excel Programming | |||
Linear Mode
