View Full Version : Specific Sheets Very Hidden
r_mundhra
04-02-2015, 03:46 AM
If anyone can help me with a Macro which would "very hide" ALL the sheets in a workbook which has "H" as the first letter in the Sheet Name field.
Thanks
Paul_Hossler
04-02-2015, 09:13 AM
Try this
Option Explicit
Sub HideHs()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If Left(ws.CodeName, 1) = "H" Then ws.Visible = xlVeryHidden
Next
End Sub
r_mundhra
04-03-2015, 01:06 AM
Thank you very much Paul. This is working perfectly.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.