Stopping ungrouping of sheets

Copper Contributor


is there a way of stopping ungrouping of sheets. 

I have 4 sheets grouped but if I'm in one of those sheets just by selecting another one in the group immediately ungroups all.

Thanks (in hope)

1 Reply


By default, Excel ungroups sheets if you select a sheet that is not in the current group.

You can prevent this behavior only by using a VBA macro (if it's possible in your excel version) that regroups the sheets when the user selects a sheet.