Need to modify reference to sheetname.

[djl0525]

I am currently using:

Sheet1.Visible = xlVeryHidden
Sheet2.Visible = xlVeryHidden
Sheet3.Visible = xlVeryHidden

to hide multiple sheets when the workbook is opened.

I have many sheets to hide. All their names end with "Help". What single command can I use to hide all sheets where the sheetname ends with "Help", please?

Thank you in advance,
DJ

 

[Oaktree]

For i = 1 To Sheets.Count
If Right(Sheets(i).Name,4) = "Help" Then Sheets(i).Visible = xlVeryHidden
Next i

 

[djl0525]

Thanks! That worked great!

DJ