How To Speed up macro

Hi Guys!

I've created a vba macro that formates the excel sheets in some defined format.
It runs quite smoothly. But then as soon as I shift the focus to some other application
the performance drastically reduces. Normal run time of 30 minutes is extended to over
2 hours. The application is quite optimized so no need to discuss about "application.screenUpdating"
and all. Please help me getting over this issue.
The problem can be of "thread priorities" (just a guess).

We probably can't help much without seeing your code, I'm afraid. Even a 30 minute run-time to do some formatting sounds excessive. What are you doing?

I don't need any syntax modification that's why I didn't posted the code.
Also may be you did not get the problem, It is related to thread priority concepts
rather than code modification that can be solved by changing syntax.

If it's a thread priority issue then it's a Windows question.

However, as per the big banner at the top of the screen, this is an Excel forum, and as an Excel developer I'd say that if your code takes 30 minutes to run, even when it has priority, it's probably not optimised.

If you're happy that it's as efficient as it possibly can be then great. Good luck with that.

Here I'm dealing with around 50 worksheets each having around 2000 lines
each needs different merging and borders. Its kind of a menu tree. I can't post
the code because of the restrictions otherwise I would already have.
Now you can understand why it is taking 30 minutes to run speed is around 12 to 15 lines per second.
I hope that is not bad the problem occurs only when the excel looses focus and you are somewhat
right that its a windows problem. But i needed to bypass that in excel.

Have you read this thread on another site? One of the responses suggests opening Excel from a .cmd file that places Excel at the highest priority.

http://superuser.com/questions/6400/...-does-not-have

And this thread discusses giving the application high priority in real time.
http://www.mrexcel.com/forum/showthread.php?t=438142

thnx Whizbang got exactly what i wanted