Excel (VBA) unhide all worksheets


/ Published in: Visual Basic
Save to your folder(s)

VBA to unhide all worksheets in an Excel workbook.


Copy this code and paste it in your HTML
  1. Sub UnhideAllSheets()
  2. Dim ws As Worksheet
  3.  
  4. For Each ws In ActiveWorkbook.Worksheets
  5. ws.Visible = xlSheetVisible
  6. Next ws
  7.  
  8. End Sub

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.