ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple windows (https://www.excelbanter.com/excel-programming/302136-multiple-windows.html)

Mike Archer[_2_]

Multiple windows
 
Hello.
Does anyone have any idea on why a particular workbook
would cause a particular machine to open 2 instances of
excel (each on a different sheet). The only thing that
the Workbook_Open() routine does is show a userform. It
seems to occur even when macros are disabled.
TIA
Mike

Tom Ogilvy

Multiple windows
 
do they have the same name but ending with :1 and :2 (the window caption).

Then someone has done Window=New Window and saved the workbook. Just click
the close button on one of the windows and then save the workbook.

--
Regards,
Tom Ogilvy

"Mike Archer" wrote in message
...
Hello.
Does anyone have any idea on why a particular workbook
would cause a particular machine to open 2 instances of
excel (each on a different sheet). The only thing that
the Workbook_Open() routine does is show a userform. It
seems to occur even when macros are disabled.
TIA
Mike




Mike Archer[_3_]

Multiple windows
 
That was it. Thank you.
-----Original Message-----
do they have the same name but ending with :1 and :2

(the window caption).

Then someone has done Window=New Window and saved the

workbook. Just click
the close button on one of the windows and then save the

workbook.

--
Regards,
Tom Ogilvy

"Mike Archer" wrote in

message
...
Hello.
Does anyone have any idea on why a particular workbook
would cause a particular machine to open 2 instances of
excel (each on a different sheet). The only thing that
the Workbook_Open() routine does is show a userform. It
seems to occur even when macros are disabled.
TIA
Mike



.



All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com