Hide All Worksheets Except Active One

Sometimes, you may need to hide all Worksheets except active one, if the Workbook have many Worksheets, it seems very boring to do it manually. In these situations, you can use this simple macro. VBA Code Sub HideAllWorksheetsExceptActive() ‘Step 1: Declare your variables Dim ws As Worksheet ‘Step 2: Start…

Unhide All Worksheets in a Workbook

If you want to unhide all Worksheets in a Workbook at once, this simple macro makes easy work for you. VBA Code Sub UnhideAllWorksheets() ‘Step 1: Declare your variables Dim ws As Worksheet ‘Step 2: Start looping through all worksheets For Each ws In ActiveWorkbook.Worksheets ‘Step 3: Loop to next…