Vba Hide Workbook On Open. The Excel VBA training video shows how to solve this problem quickly and easily and also describes other interesting aspects of transferring data from a user-form to an Excel worksheet or excel You can hide a worksheet and the user would not see it when he/she opens the workbook. If you get a response that answers your query or you see a response that explains something for you.
You cannot work in Excel without opening the Excel.
I am trying to find a way to programmatically "hide" the Workbook Queries Pane when a worksheet has a PQ rather than having the user need to close the Workbook has multiple queries (including PQ and TFS) - some refresh on open some only when the worksheet is active - those scenarios and VBA.
Learn to hide (or unhide) worksheet tabs or workbooks in Excel. I can only think of a workaround by opening this file in a separate. I have a userform in excel vba.