working on another excel sheet with an excel macro running

[AdyDimri]

How to work on another excel sheet with an excel macro running side b
side on the same system.
Problem is: When i run an excel macro i am not able to work on othe
excel sheet. i have to wait untill maro finishes the jo

 

[Gord Dibben]

That is a limitation of VBA...........while macro is running you can
do nothing else.

If you really need to do this, open two instances of Excel with a
workbook in each.

Your macro can run in one instance of Excel while you work in the
other.

BUT.............you cannot open the same workbook in both instances of
Excel.

You must open two separate workbooks.


Gord

 

[Jim Cone]

That is what it is... the macro has to finish before you can work in Excel.
Possibly your macro could be made to run faster.
Also, you could display percent completion in the status bar to avert impatience.

 

[isabelle]

hi,

vous pourriez ouvrir une deuxième instance excel

--
isabelle



Le 2012-04-06 17:04, AdyDimri a écrit :

 

[isabelle]

you could open a second instance excel

 

[Vacuum Sealed]

you could open a second instance excel

I run 2 monitors, each with a separate instance of Excel everyday on the
crappy under resourced system at work, running multiple macros
simultaneous, that said! They each have to wait their turns in the
processing highway.

HTH
Mick.