Correct Syntax to Hide Multiple Sheets

[Maverick99]

I have over 60 sheets within a workbook. There are some sheets that I want to hide or unhide depending upon the macro. I have the MR and searched in several areas but keep coming up blank with how to either select or hide these sheets.

This is from the MR:

Sheets(Array("Process", "Utilities", "CodeRef", "DataRef (3)", "DataRef (2)", "DataRef", "Dept Summary New", "Summary_Dept", Summary_ Monthly")).Select

When I try to use this in the code it errors out. I'd appreciate any help with this.

Thanks,

Maverick

 

[taigovinda]

Welcome to the board!

You mean that each time you run your macro, you want to have just two sheets remain visible - the same two each time - and everything else be hidden?

If so, look up at post #8 for the code - just replace the sheet list with the list of sheets you want to NOT be hidden.

 

[sunwf01]

Thank you very much for your help.