Add CommandBars take long time to return
 

Hi,

Somebody kindly try the following to see why it take so
long to return from Adding a CommandBars. The problem is
on 'setting the name' but we do need a name for the
CommandBars. Thanks for any help.

Michael T.

Application.CommandBars.Add Name:="MyName", Temporary:=True

Add CommandBars take long time to return
 

When I try it in MacXL04, the result is instantaneous...

What do you consider "so long"?

In article ,
"Michael" wrote:

Somebody kindly try the following to see why it take so
long to return from Adding a CommandBars. The problem is
on 'setting the name' but we do need a name for the
CommandBars. Thanks for any help.

Michael T.

Application.CommandBars.Add Name:="MyName", Temporary:=True

Add CommandBars take long time to return
 

Same here.
I use this line a lot with no slowness problems

Jason.



JE McGimpsey wrote in message ...
When I try it in MacXL04, the result is instantaneous...

What do you consider "so long"?

In article ,
"Michael" wrote:

Somebody kindly try the following to see why it take so
long to return from Adding a CommandBars. The problem is
on 'setting the name' but we do need a name for the
CommandBars. Thanks for any help.

Michael T.

Application.CommandBars.Add Name:="MyName", Temporary:=True

Add CommandBars take long time to return
 

Hi,

Thanks for trying and reply. Ok, the steps is:
1. Run Excel.
2. Do Excel menu Tools-Macros-Record New Macro'
3. Just do 'Stop Recording'
4. Open Tools-Visual Basic Editor and put the following
line into to Macro's modules function. And press F8 to
step it.
5. The line will take about 20 seconds to return.

Thanks again for all help.

MT


-----Original Message-----
Same here.
I use this line a lot with no slowness problems

Jason.



JE McGimpsey wrote in message
news:<jemcgimpsey-
...
When I try it in MacXL04, the result is instantaneous...

What do you consider "so long"?

In article ,
"Michael" wrote:

Somebody kindly try the following to see why it take
so
long to return from Adding a CommandBars. The
problem is
on 'setting the name' but we do need a name for the
CommandBars. Thanks for any help.

Michael T.

Application.CommandBars.Add Name:="MyName",
Temporary:=True
.

Add CommandBars take long time to return
 

There's something wrong with your setup. Following your steps exactly in
XL03 and XL04 result in instantaneous return for me.

I can't imagine what would cause a 20 second delay...

In article ,
"Michael" wrote:

Thanks for trying and reply. Ok, the steps is:
1. Run Excel.
2. Do Excel menu Tools-Macros-Record New Macro'
3. Just do 'Stop Recording'
4. Open Tools-Visual Basic Editor and put the following
line into to Macro's modules function. And press F8 to
step it.
5. The line will take about 20 seconds to return.

Thanks again for all help.