Again.. Userform showing wile working in other spreadsheet.

Lima Mike

Board Regular
Joined
Jun 3, 2003
Messages
70
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.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Re: Again.. Userform showing wile working in other spreadshe

In the workbook containing your UserForm, right click the Excel icon to the left ofFile on the menu and choose View Code. Paste this into the window on the right:

Code:
Private Sub Workbook_Activate()
    UserForm1.Show vbModeless
End Sub

Private Sub Workbook_Deactivate()
    UserForm1.Hide
End Sub

Press Alt+F11 to return to your workbook.

The UserForm will disappear when you activate another workbook and reappear when you return.
 

Lima Mike

Board Regular
Joined
Jun 3, 2003
Messages
70
Re: Again.. Userform showing wile working in other spreadshe

Thanks Andrew,

Will try this out when I am back at work (Still being on holiday).............

Lima Mike
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,885
Messages
5,766,936
Members
425,388
Latest member
Cave_Johnson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top