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




--

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
...
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




--

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
...
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




--