How to hide all sheets except active one in Excel
In this tutorial you will learn how to hide all worksheets except the active one in Microsoft Excel with VBA Macro Programming
VBA Code:
'This macro will hide all the worksheet except the active sheet
Sub HideAllExceptActiveSheet()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name (greater than sign - less than sign) ActiveSheet.Name Then ws.Visible = xlSheetHidden
Next ws
End Sub