S
Simon Letten
I am using a non-modal userform with a listbox and 2 command buttons. The
list box is populated with the names of the open workbooks and the Click
event activates the relevant workbook. The userform stays open. My users
typically have more than 10 books open and need to move between them
frequently and this is easier than going through the Window -->More Windows
menu.
If a user has more than 1 session of Excel open with an instance of the
userform in each session, Excel occasionally crashes (usually when the user
has just clicked on an entry in the listbox). Has anyone got any suggestions?
list box is populated with the names of the open workbooks and the Click
event activates the relevant workbook. The userform stays open. My users
typically have more than 10 books open and need to move between them
frequently and this is easier than going through the Window -->More Windows
menu.
If a user has more than 1 session of Excel open with an instance of the
userform in each session, Excel occasionally crashes (usually when the user
has just clicked on an entry in the listbox). Has anyone got any suggestions?