Home

unable to unhide hidden sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-869096%22%20slang%3D%22en-US%22%3Eunable%20to%20unhide%20hidden%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869096%22%20slang%3D%22en-US%22%3E%3CP%3ESuddenly%20I%20am%20no%20longer%20able%20to%20unhide%20hidden%20sheets%20in%20my%20workbook.%20If%20I%20right%20klick%20sheet%20tab%20the%20option%20is%20grayed%20out.%20If%20I%20in%20the%20VBA%20Project%20list%20select%20the%20sheets%20properties%20an%20try%20to%20alter%20visibility%20to%20the%20sheet%20I%20get%20unable%20to%20set%20the%20visibility%20property.%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20has%20happend%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-869096%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-869108%22%20slang%3D%22en-US%22%3ERe%3A%20unable%20to%20unhide%20hidden%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869108%22%20slang%3D%22en-US%22%3ESorry.%20I%20must%20have%20protected%20the%20workbook.%20Klick%20at%20protect%20workbook%20and%20immediately%20cancelling%20did%20the%20trick.%3C%2FLINGO-BODY%3E
SvenW
New Contributor

Suddenly I am no longer able to unhide hidden sheets in my workbook. If I right klick sheet tab the option is grayed out. If I in the VBA Project list select the sheets properties an try to alter visibility to the sheet I get unable to set the visibility property. 

What has happend?

1 Reply
Sorry. I must have protected the workbook. Klick at protect workbook and immediately cancelling did the trick.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies