Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open workbooks in different Excel?
Beauty. Thanks Dave!
"Dave Peterson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel2007; workbooks.count is not counting all open workbooks | Excel Programming | |||
VBA Excel.WorkBooks.Open can't open an XML format xls file | Excel Programming | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |