Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add CommandBars take long time to return
Hi,
Somebody kindly try the following to see why it take so long to return from Adding a CommandBars. The problem is on 'setting the name' but we do need a name for the CommandBars. Thanks for any help. Michael T. Application.CommandBars.Add Name:="MyName", Temporary:=True |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add CommandBars take long time to return
When I try it in MacXL04, the result is instantaneous...
What do you consider "so long"? In article , "Michael" wrote: Somebody kindly try the following to see why it take so long to return from Adding a CommandBars. The problem is on 'setting the name' but we do need a name for the CommandBars. Thanks for any help. Michael T. Application.CommandBars.Add Name:="MyName", Temporary:=True |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add CommandBars take long time to return
Same here.
I use this line a lot with no slowness problems Jason. JE McGimpsey wrote in message ... When I try it in MacXL04, the result is instantaneous... What do you consider "so long"? In article , "Michael" wrote: Somebody kindly try the following to see why it take so long to return from Adding a CommandBars. The problem is on 'setting the name' but we do need a name for the CommandBars. Thanks for any help. Michael T. Application.CommandBars.Add Name:="MyName", Temporary:=True |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add CommandBars take long time to return
Hi,
Thanks for trying and reply. Ok, the steps is: 1. Run Excel. 2. Do Excel menu Tools-Macros-Record New Macro' 3. Just do 'Stop Recording' 4. Open Tools-Visual Basic Editor and put the following line into to Macro's modules function. And press F8 to step it. 5. The line will take about 20 seconds to return. Thanks again for all help. MT -----Original Message----- Same here. I use this line a lot with no slowness problems Jason. JE McGimpsey wrote in message news:<jemcgimpsey- ... When I try it in MacXL04, the result is instantaneous... What do you consider "so long"? In article , "Michael" wrote: Somebody kindly try the following to see why it take so long to return from Adding a CommandBars. The problem is on 'setting the name' but we do need a name for the CommandBars. Thanks for any help. Michael T. Application.CommandBars.Add Name:="MyName", Temporary:=True . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add CommandBars take long time to return
There's something wrong with your setup. Following your steps exactly in
XL03 and XL04 result in instantaneous return for me. I can't imagine what would cause a 20 second delay... In article , "Michael" wrote: Thanks for trying and reply. Ok, the steps is: 1. Run Excel. 2. Do Excel menu Tools-Macros-Record New Macro' 3. Just do 'Stop Recording' 4. Open Tools-Visual Basic Editor and put the following line into to Macro's modules function. And press F8 to step it. 5. The line will take about 20 seconds to return. Thanks again for all help. |
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) | |||
I have done this before a long time ago, but cant remember how i d | Excel Discussion (Misc queries) | |||
long time to save | Excel Discussion (Misc queries) | |||
Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
Long time to load | Excel Programming |