Create toolbar take long time
 

Hi,

Somebody asked about the creating toolbar slowly issue
(please see below). I see the same thing on my machine.
Is there any solution/workaround for this? Thanks a lot.

Chi

/// original question:
Hi Rob,
Yes, it happens only for the creation of first toolbar.
After that it
creates the toolbars fast. Following is the code I tried,
it took about 40
seconds for the first time after starting excel and 0
seconds after that (as
it's mesured in seconds).

I have excel 2003, Version: 11.5612.5606

Sub test()
t1 = Now
Application.CommandBars.Add Temporary:=True
t2 = Now

MsgBox (t2)
MsgBox (t1)

End Sub






"Rob van Gelder" wrote:

I'm running 2003 - I don't notice any delay.

Set a breakpoint on that line, run the code, then press
F8 to step through.
Does it really take 1 minute to execute that line?

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Srini" wrote in
message
news:0D110A13-E4DD-4939-93F9-
...
Hi,

I am trying to create a toolbar and it takes a very
long time in excel
2003(about 1 minute). What's the workaround for it ?
It's very fast in
excel
2000.

Code sample:

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




--