How to run macro code and work on excel sheet simultaneously

**sharmanjali87** · 11-29-2010, 12:41 AM

Hi friends,

I have a problem that while i run my macro code i cant work on other excel sheets.I have lots of work to be done on excel so pls. if any one knows any way to run macro and work on excel simultaneously.Let me know...any help would be appriciated..Thanks in advance

**royUK** · 11-29-2010, 02:08 AM

You can't, why is your code taking so long for this to be a problem?

**sharmanjali87** · 11-29-2010, 02:36 AM

Sheets contains large no of records..thats y its taking so long....and we need to check data for each cell value

**royUK** · 11-29-2010, 03:03 AM

Switch off automatic calculation & avoid loops, that might speed up the code

**DonkeyOte** · 11-29-2010, 03:43 AM

for more general pointers see: http://blogs.msdn.com/excel/archive/...practices.aspx

failing that create a new optimisation based thread with your code and people here will assist you in terms of optimising it.