Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
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 Max Loger Excel Discussion (Misc queries) 0 June 14th 11 04:30 PM
I have done this before a long time ago, but cant remember how i d wkmooreh Excel Discussion (Misc queries) 0 May 19th 09 08:07 PM
long time to save meganrose Excel Discussion (Misc queries) 0 November 7th 07 04:48 AM
Clearing cells takes long, long time unclemuffin Excel Discussion (Misc queries) 9 August 17th 07 02:22 AM
Long time to load john Excel Programming 5 December 13th 03 06:16 PM


All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"