View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to open workbooks in different Excel?

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

MyForm.show False

Then swap windows.

Sam Kuo wrote:

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