SOLVED
Home

Rename / Delete Tabs or Lines Greyed Out

%3CLINGO-SUB%20id%3D%22lingo-sub-797310%22%20slang%3D%22en-US%22%3ERename%20%2F%20Delete%20Tabs%20or%20Lines%20Greyed%20Out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797310%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20a%20simple%20fix%20but%20I%20have%20a%20sheet%20with%20multiple%20lines%2C%20and%20multiple%20tabs.%26nbsp%3B%20I%20added%20basic%20protection%20on%20each%20sheet%20to%20prevent%20data%20being%20changed%20on%20certain%20cells.%26nbsp%3B%20Now%20even%20when%20removing%20this%20protection%20the%20options%20to%20rename%20the%20tabs%20are%20greyed%20out%20(and%20I%20would%20like%20to%20rename%20them)%26nbsp%3B%3C%2FP%3E%3CP%3EInsert%2C%20Rename%2C%20Delete%2C%20move%20or%20copy%20are%20all%20greyed%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIm%20sure%20its%20a%20super%20simple%20fix%20(but%20not%20for%20me%20of%20course!)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-797310%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797367%22%20slang%3D%22en-US%22%3ERe%3A%20Rename%20%2F%20Delete%20Tabs%20or%20Lines%20Greyed%20Out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797367%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F261917%22%20target%3D%22_blank%22%3E%40Jimbobmcwalton%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20have%20protection%20on%20the%20workbook%20level%20that%20still%20exists%20as%20the%20responsible%20for%20gray%20out%20these%20options%20is%20the%20Protect%20Workbook%20feature!%3C%2FP%3E%3CP%3EPlease%20make%20sure%20to%20remove%20it%20as%20well.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126386iE5886CBCFE2F4BF0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Protect%20Workbook.png%22%20title%3D%22Protect%20Workbook.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799500%22%20slang%3D%22en-US%22%3ERe%3A%20Rename%20%2F%20Delete%20Tabs%20or%20Lines%20Greyed%20Out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799500%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3Bthat%20worked%20great%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Jimbobmcwalton
Contributor

Hi There, 

 

Hopefully a simple fix but I have a sheet with multiple lines, and multiple tabs.  I added basic protection on each sheet to prevent data being changed on certain cells.  Now even when removing this protection the options to rename the tabs are greyed out (and I would like to rename them) 

Insert, Rename, Delete, move or copy are all greyed out.

 

Im sure its a super simple fix (but not for me of course!)

 

Can anyone help?

 

 

2 Replies
Solution

@Jimbobmcwalton

 

Hi,

 

You may have protection on the workbook level that still exists as the responsible for gray out these options is the Protect Workbook feature!

Please make sure to remove it as well.

Protect Workbook.png

 

Hope that helps

Thank you @Haytham Amairah that worked great 

Related Conversations
Rename group chat in Teams
Janneke Spiekerman in Microsoft Teams on
4 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies
delete team as last member not an owner
Alexis Dailey in Microsoft Teams on
1 Replies
Edge Dev Tabs Crash
cronhan in Discussions on
7 Replies
Closing Tabs and Drop Down Tab Previews
harshmallow in Discussions on
5 Replies
Stop tabs from refreshing
Deleted in Microsoft Teams on
11 Replies