SOLVED

Hide worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-3503454%22%20slang%3D%22en-US%22%3EHide%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3503454%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%20everybody%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20a%20problem.%20I%20want%20to%20hide%20a%20workbook%2C%20but%20this%20function%20is%20not%20available.%20How%20can%20I%20solve%20this%3F%20(see%20image%3A%20'verbergen'%20%3D%20hide)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Hanneke2445_0-1655190558189.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Hanneke2445_0-1655190558189.png%22%20style%3D%22width%3A%20140px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Hanneke2445_0-1655190558189.png%22%20style%3D%22width%3A%20140px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Hanneke2445_0-1655190558189.png%22%20style%3D%22width%3A%20140px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F380100iB9972D7466A7C195%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Hanneke2445_0-1655190558189.png%22%20alt%3D%22Hanneke2445_0-1655190558189.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3503454%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3503674%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3503674%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1423384%22%20target%3D%22_blank%22%3E%40Hanneke2445%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20that%20you%20also%20can't%20insert%20a%20new%20worksheet%20or%20delete%20one.%20If%20the%20workbook%20structure%20is%20protected%3CBR%20%2F%3Ewith%20a%20password%2C%20you're%20unable%20to%20add%2C%20delete%2C%20move%2C%20copy%2C%20remane%2C%20hide%20or%20unhide%20sheets.%3C%2FP%3E%3CP%3ECheck%20if%20you're%20using%20a%20protected%20workbook.%3C%2FP%3E%3CP%3E1.%20Go%20to%20FILE%20-%26gt%3B%20Info%3CBR%20%2F%3E2.%20If%20it%20is%20protected%20with%20a%20paswoord%20you%20have%20to%20type%20in%20the%20correct%20paswoord%20to%20unprotect%20the%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22BeyK40_0-1655193859849.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22BeyK40_0-1655193859849.png%22%20style%3D%22width%3A%20363px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22BeyK40_0-1655193859849.png%22%20style%3D%22width%3A%20363px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F380112i52AB8B9C6F5D6900%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22BeyK40_0-1655193859849.png%22%20alt%3D%22BeyK40_0-1655193859849.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3503693%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3503693%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392459%22%20target%3D%22_blank%22%3E%40BeyK40%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20thank%20you!%20It%20worked!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everybody,

 

I have a problem. I want to hide a workbook, but this function is not available. How can I solve this? (see image: 'verbergen' = hide)

 

Hanneke2445_0-1655190558189.png

 

2 Replies
best response confirmed by Hanneke2445 (New Contributor)
Solution

@Hanneke2445 

I see that you also can't insert a new worksheet or delete one. If the workbook structure is protected
with a password, you're unable to add, delete, move, copy, remane, hide or unhide sheets.

Check if you're using a protected workbook.

1. Go to FILE -> Info
2. If it is protected with a paswoord you have to type in the correct paswoord to unprotect the workbook. 

BeyK40_0-1655193859849.png

 

@BeyK40 

 

Yes thank you! It worked!