Stopping ungrouping of sheets

[Tufa298]

Hi,

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)

[#2]

@Tufa298 

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.