How to open workbooks in different Excel?

[Sam Kuo]

I have a workbook (refer as "my workbook" here) with a form (refer as "my
form" here). I've also added a custom menu item to the toolbar at the top of
Excel, with the following macro assigned to it to open my form:

Sub OpenMyForm()
MyForm.Show
End Sub

At the moment, if I have other workbooks opened already and click the custom
menu item, it opens my workbook/my form in the same Excel application as
those other workbooks. The problem with this is that I cannot switch to other
workbooks while my form is active.

Can I open my form in a NEW Excel application when I click the custom menu
item, so that I can switch between workbooks even while my form is active?

 

[Dave Peterson]

If you're using xl2k+ (IIRC), you can do:

MyForm.show False

Then swap windows.

 

[Sam Kuo]

Beauty. Thanks Dave!

If you're using xl2k+ (IIRC), you can do:

MyForm.show False

Then swap windows.