SOLVED

Can't unhide a sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2677993%22%20slang%3D%22en-US%22%3ECan't%20unhide%20a%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2677993%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20an%20excel%20that%20contains%20many%20list%20fields%2C%20with%20an%20auxiliary%20sheet%20where%20the%20values%20of%20each%20list%20are.%3C%2FP%3E%3CP%3EIt%20is%20an%20auxiliary%20sheet%20I%20have%20always%20had%20it%20hidden%20and%20I%20have%20been%20able%20to%20unhide%20it%20whenever%20I%20wanted%20to%20modify%20the%20values%2C%20until%20today.%3C%2FP%3E%3CP%3EIf%20I%20secondary%20click%20on%20any%20sheet%20to%20make%20%22unhide%22%2C%20it%20does%20not%20allow%20it%2C%20it%20appears%20disabled%20...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-08-24_8-34-22.png%22%20style%3D%22width%3A%20290px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F305307i6D8358F9D77CDB78%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-08-24_8-34-22.png%22%20alt%3D%222021-08-24_8-34-22.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThinking%20that%20it%20would%20have%20been%20deleted%2C%20ultimately%20I%20have%20entered%20in%20VBA%20editor%20and%20I%20have%20seen%20that%20the%20sheet%20is%20still%20there%2C%20with%20the%20property%20hidden%2C%20but%20if%20I%20change%20the%20property%2C%20an%20error%20appears%20that%20does%20not%20allow%20me%20to%20visualize%20it%20(see%20image)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-08-24_8-27-20.png%22%20style%3D%22width%3A%20711px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F305308i2341A0192E74FFDD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-08-24_8-27-20.png%22%20alt%3D%222021-08-24_8-27-20.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20retrieve%20this%20sheet%3F%20I%20need%20to%20be%20able%20to%20edit%20it%20and%20the%20main%20sheet%20with%202%20thousand%20lines%20and%2015%20fields%20listed%20per%20line%20takes%20all%20the%20data%20from%20there%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2677993%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2678084%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2678084%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1135898%22%20target%3D%22_blank%22%3E%40Mouzo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20the%20workbook%20has%20been%20protected%20for%20structure.%3C%2FP%3E%0A%3CP%3EActivate%20the%20Review%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EIs%20the%20Protect%20Workbook%20button%20in%20the%20Protect%20group%20highlighted%3F%20If%20so%2C%20click%20it%20to%20turn%20it%20off.%20You%20may%20have%20to%20provide%20a%20password.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2678596%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20unhide%20a%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2678596%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1135898%22%20target%3D%22_blank%22%3E%40Mouzo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFrom%20the%20look%20of%20the%20context%20menu%20in%20your%20screenshot%2C%20the%20workbook%20is%20still%20protected...%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, I have an excel that contains many list fields, with an auxiliary sheet where the values of each list are.

It is an auxiliary sheet I have always had it hidden and I have been able to unhide it whenever I wanted to modify the values, until today.

If I secondary click on any sheet to make "unhide", it does not allow it, it appears disabled ...

2021-08-24_8-34-22.png

Thinking that it would have been deleted, ultimately I have entered in VBA editor and I have seen that the sheet is still there, with the property hidden, but if I change the property, an error appears that does not allow me to visualize it (see image)

2021-08-24_8-27-20.png

Does anyone know how to retrieve this sheet? I need to be able to edit it and the main sheet with 2 thousand lines and 15 fields listed per line takes all the data from there ...

 

Thank you very much for the help!

7 Replies

@Mouzo 

Perhaps the workbook has been protected for structure.

Activate the Review tab of the ribbon.

Is the Protect Workbook button in the Protect group highlighted? If so, click it to turn it off. You may have to provide a password.

Thank you @Hans Vogelaar 

Yes, the workbook it's protected because it's a shared workbook.

But, when I have to update it, I unprotect the workbook. I had done this, and always it worked fine, but this time, I can't do it :(.

 

I tried to re-protect and unproted but doesn't work...

@Mouzo 

From the look of the context menu in your screenshot, the workbook is still protected...

Yeah, in the context menu, but in the ribbon not

@Mouzo 

Could you attach a copy of the workbook? You can remove all visible sheets except one, and clear the remaining visible sheet.

@Hans Vogelaar Thank you

 

I found the problem!

When I "unshared and unprotect the workbook", i tried to "unprotect again only the workbook", and SUPRISE, I could unhide the sheets...

 

Thank you for you attentions and help!

best response confirmed by Mouzo (New Contributor)
Solution

@Mouzo 

I'm glad to hear you found the solution!