Big problems using more than one window

  • Thread starter Thread starter =?iso-8859-1?Q?mogens_s=F8gaard?=
  • Start date Start date
?

=?iso-8859-1?Q?mogens_s=F8gaard?=

I´m having a hard time making excel function propperly
with more than one window open.
I´m opening a new window in order to let users navigate
the application via a treeview control.
BUT... if I didn´t save the workbook with two windows open
before I opened it, the new window opened is not active
meaning that buttons, treeview etc. cannot be activated:

This Works:
Open two windows save the workbook close excel, open
workbook again, now you can open and close windows without
loosing the ability to activate controls.

This doesn´t work:
Save workbook with one window open, close excel, open
workbook, open new window -- All controls are inactive in
new window.

Anyone have an aswer to this "undocumented feature"

BR
Mogens
 
Hei Mogens

It's a known (?) weakness that ActiveX controls doesn't work in Window 2 up,
only in Window 1, for some reason the "main window". I suggest you make the
workbook_open event organize the windows in working order. Or you could put
the navigation tools onto a modeless userform instead of a spreadsheet.

--
HTH. Best wishes Harald
Excel MVP
Followup to newsgroup only please

"mogens søgaard" <[email protected]> skrev i melding
I´m having a hard time making excel function propperly
with more than one window open.
I´m opening a new window in order to let users navigate
the application via a treeview control.
BUT... if I didn´t save the workbook with two windows open
before I opened it, the new window opened is not active
meaning that buttons, treeview etc. cannot be activated:

This Works:
Open two windows save the workbook close excel, open
workbook again, now you can open and close windows without
loosing the ability to activate controls.

This doesn´t work:
Save workbook with one window open, close excel, open
workbook, open new window -- All controls are inactive in
new window.

Anyone have an aswer to this "undocumented feature"

BR
Mogens
 
Back
Top