View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Kuo[_3_] Sam Kuo[_3_] is offline
external usenet poster
 
Posts: 86
Default How to open workbooks in different Excel?

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?