Advanced Search

Excel (VBA) unhide all worksheets

/ Published in: Visual Basic
Save to your folder(s)
VBA to unhide all worksheets in an Excel workbook.

Expand | Embed | Plain Text

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.