Unhide All Hidden Worksheets At Once

If you have a workbook with many hidden worksheets, you cannot unhide all of them at once, UNLESS, you use the below VBA Code..

------------------------------------------------------------------

Option Explicit Sub UnHideAllSheets() 'Unhides All Worksheets Dim Sheet As Worksheet Application.ScreenUpdating = False For Each Sheet In ActiveWorkbook.Worksheets Sheet.Visible = xlSheetVisible Next Sheet Application.ScreenUpdating = True End Sub

------------------------------------------------------------------

By the way, I also know a nice trick for hiding your worksheets to keep it safe from people you don't want to share them with.

Check it out -

#excel2007 #excel2010 #excel2013 #excel #excellessons #excelprogramming #excelshortcuts #exceltips #exceltricks #exceltutorials #macros #microsoftexcel #msexcel #office #vba

Follow Us
  • Twitter Basic Square
  • Google+ Basic Square
Recent Posts
Search By Tags
No tags yet.