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

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

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

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

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