How to Unhide Multiple Sheets in Excel
How to Unhide Multiple Sheets in Excel
1. Open Excel workbook
2. Right Click on any Visible Sheet -- View Code
3. Separate VB Editor will be opened
4. Goto View Menu -- open Immediate window
5. Type this Code or Copy Paste and Press Enter Key.
For each Sheet in Thisworkbook.Sheets: Sheet.Visible=True: Next Sheet