In this video, I will show you how to unhide worksheets in Excel (with or without VBA).
In Excel, you can hide multiple worksheets at one go but you can not unhide multiple sheets at one go. If you use the inbuilt functionality to unhide sheets, it will only unhide one sheet at a time.
However, there are a couple of methods you can use to unhide all sheets at one go in Excel.
This video covers the following methods to unhide sheets:
-- Manually Unhide one sheet at a time
-- Unhide all sheets using VBA code in the immediate window
-- Unhide all sheets by using a VBA macro code and adding it to the quick access toolbar
-- Unhide sheets using custom view option.
With VBA immediate window, you can quickly run a line of code by simply adding it in the immediate window and hitting the enter key.
Below is the line of code to use in the immediate window in the VB Editor:
For each Sheet in Thisworkbook.Sheets: Sheet.Visible=True: Next Sheet
As soon as you hit the enter key (after placing the cursor at the end of the line), it will instantly unhide all the hidden sheets.
The good thing about this is that you don't need to save the Excel workbook as a macro-enabled workbook.
======================================================
This video solves below queries.
1. Unhide all sheets in excel.
2. Unhide all sheets in excel without VBA code
3. Visible all sheets in excel.
4. How to unhide all sheets in excel with on click.
======================================================
Also take a look at more videos
1. Excel Magical Tricks & Tips Videos.
Link - [ Ссылка ]
2. Power Query Amazing Tips & Tricks.
Link - [ Ссылка ]
3. Power BI Dashboard Tips.
Link - [ Ссылка ]
4. DAX real life scenarios.
Link - [ Ссылка ]
