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…

Save and Close All Workbooks at Once

Sometimes you may need to save and close many workbooks at once. For each workbook you have opened, you need to activate the work, close it, and confirm save changes. There is no easy way to close them all down at one time. This little macro takes care of that…