Someone protected workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1736944%22%20slang%3D%22en-US%22%3ESomeone%20protected%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1736944%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20complicated%20workbook%20with%20numerous%20tabs%20that%20another%20user%20protected%20and%20possibly%20shared.%26nbsp%3B%20It%20has%20%7BGroup%7D%20after%20the%20name%20of%20the%20workbook%20at%20the%20top%20of%20the%20workbook.%26nbsp%3B%20I%20need%20to%20make%20changes%20but%20nobody%20is%20owning%20up%20to%20changing%20anything.%26nbsp%3B%20Under%20the%20Review%20option%20in%20the%20menu%2C%20there%20is%20no%20option%20to%20unprotect%20the%20workbook.%26nbsp%3B%20anything%20I%20can%20do%20to%20correct%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1736944%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1737012%22%20slang%3D%22en-US%22%3ERe%3A%20Someone%20protected%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1737012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F817047%22%20target%3D%22_blank%22%3E%40John__Boy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%5BGroup%5D%20means%20that%20multiple%20sheets%20have%20been%20selected.%20Right-click%20any%20of%20the%20selected%20sheet%20tabs%20and%20select%20Ungroup%20Sheets%20from%20the%20context%20menu.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

2 Replies
Highlighted

@John__Boy 

[Group] means that multiple sheets have been selected. Right-click any of the selected sheet tabs and select Ungroup Sheets from the context menu.

Highlighted

@Hans VogelaarThanks.  That took care of the problem.  I never group tabs, so wasn't aware of this.