Thanks for the replys but this is not the problem.
See below the original question. If I use the Modeless option as suggested by several people then indeed I can work in the spreadsheet but what I need is that in the second workbook that has been opened by a macro the userform does not show while in the original workbook it still does. Thus if I switch between workbooks via the buttons in the bottom bar of windows the userform only shows in the original and not in the newly opened workbooks.
Any idea?????????????
Lima Mike
Userform showing wile working in other spreadsheet.
The Excel application I made shows a UserForm that covers the whole screen. All dealings with the underlying data in the underlying spreadsheets are done through this overlaying UserForm.
One option I like to build is output in the form of a new Workbook but I cannot access this new workbook as long as the Userform is “on” in the original application (Workbook).
I tried to start up another copy of Excel. In this case I can go to the newly created workbook but I cant transfer data from the first workbook to the second in the other copy of Excel.
How can I still see (and use) the second spreadsheet while the UserForm in the original spreadsheet still shows?
Lima Mike.
See below the original question. If I use the Modeless option as suggested by several people then indeed I can work in the spreadsheet but what I need is that in the second workbook that has been opened by a macro the userform does not show while in the original workbook it still does. Thus if I switch between workbooks via the buttons in the bottom bar of windows the userform only shows in the original and not in the newly opened workbooks.
Any idea?????????????
Lima Mike
Userform showing wile working in other spreadsheet.
The Excel application I made shows a UserForm that covers the whole screen. All dealings with the underlying data in the underlying spreadsheets are done through this overlaying UserForm.
One option I like to build is output in the form of a new Workbook but I cannot access this new workbook as long as the Userform is “on” in the original application (Workbook).
I tried to start up another copy of Excel. In this case I can go to the newly created workbook but I cant transfer data from the first workbook to the second in the other copy of Excel.
How can I still see (and use) the second spreadsheet while the UserForm in the original spreadsheet still shows?
Lima Mike.