Speed up code, disable calculation on all sheets except active

Hi,

I have built a very simple form where the enduser fills in a few information, which after pressing a button are being saved on the "data" sheet. you can see the vba code below:

Please Login or Register  to view this content.

Now, the problem is that I am pulling a rather complex data analysis on the "summary" sheet of the same workbook, which is full with sumproduct formulas and takes quite the edge off the ancient office computers that my company is using. What I want to do is to disable the Excel formula calculation in the entire workbook EXCEPT the "form" sheet, and after the job is done, turn the calculation back on WITHOUT refreshing it.

I also disabled several events etc. to speed things up, but the main performance issue always the formula calculation on the "summary" sheet.

Any ideas?
Thanks,

A2k

Thanks guys, I changed most of the formulas to COUNTIF instead and it runs much faster now. Appreciate it.