Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 3rd 11, 08:50 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2011
Posts: 2
Default VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs

Topic: VBA macro runs fine, but freezes if I try to do ANYTHING else
while it runs

I have a very large Excel spreadsheet (13 MB) with several macros. One
of them runs a loop with multiple commands.

The macro runs fine, as long as I sit back and just watch it run. If I
click on another window however, it invariably freezes and I have to
terminate Excel.

Any ideas on how I can remedy this?

I'm running Excel 2003 on Windows XP, but have noticed the same
problem with the same spreadsheet on a machine running Excel 2007,
also on Windows XP.

Thanks,

-Sharat

  #2   Report Post  
Old September 17th 11, 01:25 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 143
Default VBA macro runs fine, but freezes if I try to do ANYTHING elsewhile it runs

On Aug 3, 3:50*pm, Rruffpaw wrote:
Topic: VBA macro runs fine, but freezes if I try to do ANYTHING else
while it runs

I have a very large Excel spreadsheet (13 MB) with several macros. One
of them runs a loop with multiple commands.

The macro runs fine, as long as I sit back and just watch it run. If I
click on another window however, it invariably freezes and I have to
terminate Excel.

Any ideas on how I can remedy this?

I'm running Excel 2003 on Windows XP, but have noticed the same
problem with the same spreadsheet on a machine running Excel 2007,
also on Windows XP.

Thanks,

-Sharat


Re-code the macro with periodic DoEvents. This will allow you to
program in pauses to allow user actions


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
Excel Macro runs fine, but freezes if I try to do ANYTHING else whileit's running Rruffpaw Setting up and Configuration of Excel 0 August 3rd 11 08:31 PM
Why macro runs on the same sheet? Harshad[_2_] Excel Discussion (Misc queries) 1 September 15th 08 09:39 AM
I need a macro that runs other macros until P5=28 Jeff Excel Discussion (Misc queries) 6 May 7th 08 11:44 PM
One macro runs then it auto runs another macro PG Excel Discussion (Misc queries) 2 September 1st 06 09:30 PM
Which Macro Runs...? Bill Martin Excel Discussion (Misc queries) 7 September 29th 05 12:42 PM


All times are GMT +1. The time now is 01:55 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017