Forum Discussion
Tufa298
Apr 20, 2023Copper Contributor
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...
NikolinoDE
Apr 22, 2023Gold Contributor
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.