Get Unhide Worksheet Background. Hiding sheets in excel is easy, but unhiding all sheets is not as simple. This tutorial covers hide a worksheet so that it can not be unhidden hide/unhide worksheets using vba so let's see how you can really hide a worksheet so that it can not be unhidden (at least not so.
Hide and Unhide Worksheets and Workbooks in Excel 2007 & 2010 from www.howtogeek.com
The unhide command will not display those hidden. Hide or unhide worksheets this macro demonstrates how to unhide a worksheet, and also how to hide it so that it can only be unhidden by a macro. Now, custom views are fine if you already have your sheets unhidden dim hiddensheet as worksheet.
Hide / unhide sheets in the vba editor.
Sub unhide() dim ws as worksheet for each ws in sheets ws.visible = true next end sub. It is easy to hide sheets in excel, but probably unhide multiple worksheets at once would be not so easy to do, if you cannot find an effective way. The unhide command will not display those hidden. For each ws in activeworkbook.worksheets.
