Open new instance of excel window if an excel window already open

I am trying to find a way so that when ever a user opens a particular workbook it always opens in a new window.
I have a user form attached to this workbook.

I tried using this code and inserted into the workbook Open event.

Please Login or Register  to view this content.

good news and bad news.. first it does open a new window.. bad news it keeps wanting to open a new instance non stop.. and kicks out a waiting for OLE error.. So where am I suppose to put this code? here is the full code... if I'm not suppose to put it in the workbook_Open event then where?..

Please Login or Register  to view this content.

Originally Posted by Dariusd7

I am trying to find a way so that when ever a user opens a particular workbook it always opens in a new window.
I have a user form attached to this workbook.

I tried using this code and inserted into the workbook Open event.

Please Login or Register  to view this content.

good news and bad news.. first it does open a new window.. bad news it keeps wanting to open a new instance non stop.. and kicks out a waiting for OLE error.. So where am I suppose to put this code? here is the full code... if I'm not suppose to put it in the workbook_Open event then where?..

Please Login or Register  to view this content.

thanks ok...............

Originally Posted by Leith Ross

Hello Dariusd7,

A workbook can not decide to open itself in a new instance of Excel. However, you can have an open workbook run a macro to open another workbook in a new instance Excel.

You can do this in using the Shell command. Here is an example to open the workbook from your macro...

Please Login or Register  to view this content.

So can I use workbookA to open workbookB and then use code something like thisworkbook.close to close WorkbookA after workbookB is opened?