Need to expand a macro to not run if worksheet is not visible

[Catthy]

I have the following macros to open or close worksheets. The workbook will be used by a number of users and if the worksheets are closed and the macro button is selected and error appears as below? What statement should I include in this macro so it doesn't error if the worksheets are not visible. Also if the macro is untidy is there a more efficient way to write it. I image I need to do some sort of If statement but not sure what to write.

Please Login or Register  to view this content.

I get a Run-time error '1004' Select method of sheets class failed if the

Thanks

[JBeaucaire]

Maybe this instead to run through each sheet individually rather than trying to "select a hidden sheet" which is not possible.

Please Login or Register  to view this content.

[Catthy]

Thanks Jerrry

A much better macro

[JBeaucaire]

If that resolves your need, please select Thread Tools from the menu above and mark the thread as solved. Thanks.