I have a project that uses a UDF that calculates almost constantly (not set to Volitile). Because of this the project runs slowly for me and the end users. In an effort to speed it up a bit I turned off the Automatic Calculation on those worksheets that use the UDF, using the below code.

Please Login or Register  to view this content.
The only time I really want the UDF to calculate is when an event is kicked off so I added the line 

Please Login or Register  to view this content.
To the end of my Event Procedure.

This had the desired effect of speeding up the entire project.
However, and unforeseen side effect is that I can no longer copy from one worksheet to another (if the source worksheet is one that is set to CalculationManual on Deactivate)

Anyone ever had this issue? Know of anyway to set specific worksheets to CalculateManual and still have the rest of the functionality of Excel?

Thanks