Is there anyway that, when open the workbook we can say that it should only open the Visible sheets?
I know that we can open only desire sheets by saying the sheetname in the LoadOptions(), but I’m wondering if is not possible to add another property to LoadOptions to Just Open Visible sheets in Workbook.
We have a worsheet that has more than 200 sheets, but visible (each time) we have only 5 - 10… The name’s of the sheet can vary, so it’s not easy to say the sheet name’s to LoadOptions…
If there’s anyway to do this please let me know, otherwise can you consider this update?
thanks in advance,