Display workbook tabs

[dillyoh]

If I have this to false and then use those workbooks in my script will excel error?

currently I’m hiding/unhiding sepetate tabs which gets a bit messy if one is already hidden or unhidden.

 

[Yongle]

A workbook must always have at least one visible sheet
- FIRST unhide sheets requred to be visible
- THEN hide sheets requred to be hidden
- this prevents the risk that you try to hide EVERY sheet

Some code can only run if the sheet is visible
- sometimes the code can be rewritten to avoid this problem
- otherwise unhide the sheet early in the code and hide it again after the code has done what you want

If you want any further help, please explain fully what your problem is and what you are trying to achieve

thanks

 

[Peter_SSs]

If I have this to false ...

.. or do you mean the setting in
File -> Options -> Advanced -> Display options for this workbook -> Show sheet tabs?