Having a Workbook Open but not visible to the user

[dougman824]

Hello,

I have a File that is driven by macros. These what I will call activation controls I have placed on the ribbon. I have learned that once you assign a macro to the ribbon that it will open the workbook every time the button is clicked. I am fine with this as I will just have essentially a placeholder workbook to hold all of these controls. My issue is I just don't want the user to know that that workbook is open while they work.

I'm basically looking for some ideas that would be similar to workbook.show that I could run on the opening event of the placeholder workbook.

[CK76]

May be you can open workbook in new instance of Excel like below and set it to visible = False. Though you may need to modify existing code to read/use the workbook from new instance.

Please Login or Register  to view this content.

[dougman824]

I won't have time to check this today but that does seem to be what I am looking for. I will mark it as solved on Monday if it works. Thanks