Create toolbar take long time

  • Thread starter Thread starter Chi
  • Start date Start date
C

Chi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top