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

9 views
Skip to first unread message

sharatch

unread,
Aug 3, 2011, 3:53:11 PM8/3/11
to exce...@googlegroups.com
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

Dileep V

unread,
Aug 4, 2011, 1:07:26 AM8/4/11
to exce...@googlegroups.com

Hi'
This happens for two reasons:
A. Junk and temp files in u r system. Clean it up first incl. History.
B. Set calculation options to manual frm automatic.

Thanks & regards,
Dileep V
~~~~~~~~~~~~~~~
Sent from my galaxy mobile.
Plz ignore typos !

> --
> You received this message because you are subscribed to the Google Groups "MS Excel Macro Vba" group.
> To view this discussion on the web visit https://groups.google.com/d/msg/excel_vba/-/SOYn19OiY2oJ.
> To post to this group, send email to exce...@googlegroups.com.
> To unsubscribe from this group, send email to excel_vba+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/excel_vba?hl=en.
>

deepu

unread,
Sep 8, 2011, 7:20:41 AM9/8/11
to MS Excel Macro Vba
There're 2 reasons of it....
1st You've opened all the excel file in a one single window...
2nd You're running the macro in the same window...

Look, I don't know whether you've noticed it or not?? But whenever we
open Excel using start menu or any other way, an instance/object gets
created of the application, and next time when you double click on any
excel file or press CTRL+O to open an another Excel file than the new
file gets open but in the same instance or object, and if you run any
macro from any of these workbooks this will not allow you to do
anything untill the execution of the macro gets completed.. lets say
you've opened 10 workbooks in a single instance/object and you run a
time consuming macro from any of them, than you'll not able able to
work on any of these workbooks...

What's the solution....

lets say you've to work on 10 different workbooks..but your macro is
in a single workbook... than what you have to do is..

Step 1 >> Click on 'Start' button select 'Run' and type Excel, Excel
window will be opened, now open your macro file using CTRL+O key...
Step 2 >> Click on 'Start' button, select 'Run' and type Excel,
again, Excel window will be opened.. Now you can open your others
files on which you've to continue to your work...

What's happening....

You may have noticed, in Step 1 & in Step 2 you've opened Excel window
two times.. means you've created two different instances/objects...
Whatever you do in Object 1 will not affect Object 2's properties...

Run your macro from the macro workbook and continue to your work in
other workbooks.....


Regards
Deepak





On Aug 4, 10:07 am, Dileep V <vdileep...@gmail.com> wrote:
> Hi'
> This happens for two reasons:
> A. Junk and temp files in u r system. Clean it up first incl. History.
> B. Set calculation options to manual frm automatic.
>
> Thanks & regards,
> Dileep V
> ~~~~~~~~~~~~~~~
> Sent from my galaxy mobile.
> Plz ignore typos !
> On 4 Aug 2011 10:34, "sharatch" <shara...@hotmail.com> 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
>
> > --
> > You received this message because you are subscribed to the Google Groups
>
> "MS Excel Macro Vba" group.> To view this discussion on the web visit
>
> https://groups.google.com/d/msg/excel_vba/-/SOYn19OiY2oJ.> To post to this group, send email to exce...@googlegroups.com.
> > To unsubscribe from this group, send email to
>
> excel_vba+...@googlegroups.com.> For more options, visit this group at
>
> http://groups.google.com/group/excel_vba?hl=en.
>
>
>
> - Hide quoted text -
>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
Reply all
Reply to author
Forward
0 new messages