| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When useform is openning, I cannot open another workbook.
Hi all
When I am running a userform, I try to open another workbook at the same time. But, the workbook could not be openned. Please could you suggest me how to do that ? Thank you for your assistance. Cheers, Gary Ho |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When useform is openning, I cannot open another workbook.
Did you try opening another Excel instance?
-- HTH, Barb Reinhardt "Gary Ho" wrote: Hi all When I am running a userform, I try to open another workbook at the same time. But, the workbook could not be openned. Please could you suggest me how to do that ? Thank you for your assistance. Cheers, Gary Ho |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When useform is openning, I cannot open another workbook.
Have you tried to open another instance of Excel?
-- HTH, Barb Reinhardt "Gary Ho" wrote: Hi all When I am running a userform, I try to open another workbook at the same time. But, the workbook could not be openned. Please could you suggest me how to do that ? Thank you for your assistance. Cheers, Gary Ho |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When useform is openning, I cannot open another workbook.
Yes, I tried to open another instance of Excel in manual. But, not successful.
Thx. "Barb Reinhardt" wrote: Have you tried to open another instance of Excel? -- HTH, Barb Reinhardt "Gary Ho" wrote: Hi all When I am running a userform, I try to open another workbook at the same time. But, the workbook could not be openned. Please could you suggest me how to do that ? Thank you for your assistance. Cheers, Gary Ho |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
When useform is openning, I cannot open another workbook.
Right-click on the Userform in design mode and select Properties.
Change ShowModal to False. Gord Dibben MS Excel MVP On Wed, 25 Nov 2009 19:54:05 -0800, Gary Ho wrote: Yes, I tried to open another instance of Excel in manual. But, not successful. Thx. "Barb Reinhardt" wrote: Have you tried to open another instance of Excel? -- HTH, Barb Reinhardt "Gary Ho" wrote: Hi all When I am running a userform, I try to open another workbook at the same time. But, the workbook could not be openned. Please could you suggest me how to do that ? Thank you for your assistance. Cheers, Gary Ho |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook Openning | Excel Programming | |||
| Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
| import data without openning excel workbook | Excel Programming | |||
| Excel: useform and shapes | Excel Programming | |||
| Listbox on a useform | Excel Discussion (Misc queries) | |||
Hybrid Mode
