Home ยป xlSheetVisible

Hide All Worksheets Except Active One

    Programming  15014 0

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

    Programming  3606 0

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…