long time to create toolbar in excel 2003
 

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




--

long time to create toolbar in excel 2003
 

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




--

long time to create toolbar in excel 2003
 

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




--