The best magazine
- 1). Double-click your Excel file to launch it in Microsoft Excel.
- 2). Press "Alt" + "F11" to open the Microsoft Visual Basic editor in another window.
- 3). Click "Insert" at the top of the window, then click "Module."
- 4). Type
Sub UnhideAllSheets()
Dim wsSheet As Worksheet
For Each wsSheet In ActiveWorkbook.Worksheets
wsSheet.Visible = xlSheetVisible
Next wsSheet
End Sub
into the module window, then click the red "X" at the top right corner to close the module window. - 5). Return to the Microsoft Excel window.
- 6). Click the "View" tab at the top of the window.
- 7). Click the "Macros" button, then click "View Macros."
- 8). Click "UnhideAllSheets," then click "Run."
Source: ...