Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ungroup worksheets
Hi everyone,
Is there a way to ungroup worksheets on a workbook open event? Some of my users are leaving worksheets grouped when they save the workbook. Then, when the next person goes to use the workbook they make changes to all of the worksheets instead of just one worksheet. I know that it's a user education problem but it's just easier to program it in if I can. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ungroup worksheets
ActiveSheet.Select
should do it. -- Jim Rech Excel MVP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ungroup worksheets
Thanks guys that was excelent, especially the ActiveSheet.Select.
"Township of East Hanover" wrote in message ... Hi everyone, Is there a way to ungroup worksheets on a workbook open event? Some of my users are leaving worksheets grouped when they save the workbook. Then, when the next person goes to use the workbook they make changes to all of the worksheets instead of just one worksheet. I know that it's a user education problem but it's just easier to program it in if I can. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ungroup and Group - Faded out | Excel Discussion (Misc queries) | |||
group&ungroup | Charts and Charting in Excel | |||
How to UNGROUP worksheets, please? | Excel Worksheet Functions | |||
Help with Group/Ungroup | Excel Discussion (Misc queries) | |||
how do you ungroup a spreadsheet | Excel Discussion (Misc queries) |