Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Long time user,can't create a chart-help! | Charts and Charting in Excel | |||
Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
long time to create toolbar in excel 2003 | Excel Programming | |||
A better way to create this function. To long for Data Validation. | Excel Programming |