Excel very slow! Please Help!!!!

[gustaf111]

Hello!!

I have a template with vba code, after I have used the template, somtimes excel comes in a mode that runs the vba very slow!!! What can that be ??

Please help!!!!!

 

[gustaf111]

I'm running out of stack! How can I see the stack ?

 

[gustaf111]

The call stack is ok! What can it be ?

Please help!!!

 

[wigi]

The call stack is ok! What can it be ?

Please help!!!

How should helpers know without seeing the template?

At the very least, describe it accurately, including VBA code you use.

 

[gustaf111]

I run the same code and at some pount and forward the same runs very slow! I have checked the call stack and that is okay.

What more can I check ?

 

[gustaf111]

What could it be ? Then I play around with the template, suddently the code runs very slow! I set a break point in the code and can se that it runs extreamply slow !

 

[gustaf111]

I found that is I change somthing in the header of excel, for example the scale when you write out, after that the vba code runs very slow!

 

[gustaf111]

If I just do print preview and run code after that, the code is very slow!! Nothing else!

What can that be ??

 

[wigi]

I have no clue what it could be. Moreover, you do not describe or post the code you are using, even when advised earlier.

 

[gustaf111]

Thanks for taking time! I found the problem! After print preview the code went slow! And I found this thread:

http://dmcritchie.mvps.org/excel/slowresp.htm

I disable page break after and when it worked!!

Thanks!