Excel Vba Unhide All Sheets In Workbook. Hiding multiple worksheets in an excel workbook is quite easy; There must be one sheet visible all the time.
Tab control will setup a control sheet in your workbook with a list of all the worksheet names. Sub vba_hide_sheet() dim ws as worksheet for each ws in thisworkbook.sheets if activesheet.name <> ws.name then ws.visible = false end if next ws end sub. Follow this answer to receive notifications.