djl0525
Well-known Member
- Joined
- Dec 11, 2004
- Messages
- 1,240
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
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