Forum Discussion

Tufa298's avatar
Tufa298
Copper Contributor
Apr 20, 2023

Stopping ungrouping of sheets

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)

excel
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Apr 22, 2023

    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.

Resources