manual calculation after copying worksheets?

[cterjesen]

Any idea why the calculation would switch to manual when I copy certain worksheets out of a workbook to a new file? Even once I hit F9, the calculation message remains in the status bar.

Also, once I do this every time I enter data into a cell, Excel tries to "calculate" which takes a second or so.

If I close out of Excel and open it back up, things are fine.

By the way, this only happens when I copy certain worksheets out of the file and not others. Is there some setting in that worksheet that would cause this?

Thanks!

 

[AlphaFrog]

If the code is the same as what you had posted in your other thread, then it looks like you are switching to...
Application.Calculation = xlCalculationManual

...and not switching back to
Application.Calculation = xlCalculationAutomatic

But you may be doing that and just didn't post that part of the code.

 

[cterjesen]

That part of the code is there. I probably cut it off. I copied your code in and tried to run it and received the same error. For some reason it doesn't like certain worksheets in the file when it tries to extract them.