Unhide an excel sheet - Very Hidden Code

New Contributor

How do you unhide a 'very hidden' excel sheet?  I cant seem to undo the code that I put in

2 Replies

@zwesolowski On the Developer ribbon, choose Visual Basic. This opens the VB Editor with a sidebar that displays all VBA projects, even if there is no VBA code. You should see the sheet that it "very hidden". Click on its name and in the very last field in the bottom part of the sidebar, change the setting in the dropdown box where it says "2 - xlSheetVeryHidden"

Screenshot 2021-11-12 at 13.52.33.png

 

@Riny_van_Eekelen That worked.  Thanks!