Hiding Worksheets by number

[Yoepy]

Hopefully just a simple one.

How do I hide all worksheets with a worksheet number greater than 12?

I suppose I could list every sheet I don't want to hide like below, but they must be a cleaner way

Thank you.

Please Login or Register  to view this content.

[Phuocam]

Try this:

Please Login or Register  to view this content.

[Yoepy]

Sorry, I should have been clearer. I need to use the number >12 as per the VBA properties. So the list per the Microsoft Excel Objects "Sheet1", "Sheet2" etc. Which have of course all been named.

[Phuocam]

Like this?

Please Login or Register  to view this content.

[Yoepy]

Perfect! Thank you Phuocam.