Macro
 

Whenever I run a macro , I am unable to minimize Excel and hence can't
work on anything else. Is there a setting to be able to run in
background ?


--
dbodd
------------------------------------------------------------------------
dbodd's Profile: http://www.excelforum.com/member.php...o&userid=31249
View this thread: http://www.excelforum.com/showthread...hreadid=512076

Macro
 

Use DoEvents statements inside your macro - especially inside any loops. e.g:

For i = 1 to 1000
DoEvents
' Code for loop
Next i

DoEvents lets Excel process actions outside of your macro (including
minimizing it).
--
- K Dales


"dbodd" wrote:


Whenever I run a macro , I am unable to minimize Excel and hence can't
work on anything else. Is there a setting to be able to run in
background ?


--
dbodd
------------------------------------------------------------------------
dbodd's Profile: http://www.excelforum.com/member.php...o&userid=31249
View this thread: http://www.excelforum.com/showthread...hreadid=512076

Macro
 

Hi K Dales,
Many thanks for the help. It works like a dream.
Regards , D Bodd.


--
dbodd
------------------------------------------------------------------------
dbodd's Profile: http://www.excelforum.com/member.php...o&userid=31249
View this thread: http://www.excelforum.com/showthread...hreadid=512076