Apr 20 2023 12:48 PM
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)
Apr 22 2023 01:40 AM
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.