Advanced Search

Excel (VBA) hide specific worksheets

/ Published in: Visual Basic
Save to your folder(s)
Hide specific worksheets in a workbook that contain a prefix. This example uses "Admin_", although this can be changed easily.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. Sub HideAdminSheet()
  2.     Dim ws As Worksheet
  3.  
  4.     For Each ws In ActiveWorkbook.Worksheets
  5.         If Left(ws.Name, 6) = "Admin_" Then
  6.             ws.Visible = xlSheetHidden
  7.         End If
  8.     Next ws
  9.  
  10. End Sub

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.