Oct 01 2020 02:05 PM
I have a complicated workbook with numerous tabs that another user protected and possibly shared. It has {Group} after the name of the workbook at the top of the workbook. I need to make changes but nobody is owning up to changing anything. Under the Review option in the menu, there is no option to unprotect the workbook. anything I can do to correct this issue?
Thanks
Oct 01 2020 02:27 PM
[Group] means that multiple sheets have been selected. Right-click any of the selected sheet tabs and select Ungroup Sheets from the context menu.
Oct 01 2020 02:38 PM
@Hans VogelaarThanks. That took care of the problem. I never group tabs, so wasn't aware of this.