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