At my work, we populate an Excel form. The form does a few calculations that are the basis for programming some pumps. If the pumps are programmed wrong, they can burst the piping which is a safety issue.

Is there any way to absolutely (with 100% certainty) to force Excel to always be in automatic calculation mode? Or at least to be in automatic calculation mode when we print the form? We often have multiple sheets open, and some of them are in manual calculation mode. This can lead to the calculation mode inadvertently getting turned off in our form. Because safety is at risk, I need a way to ensure this sheet never gets switched. I know know how to write a VBA module to ensure the sheet opens in automatic mode, but I don't know how to prevent this from happening while the sheet is open.

At present, our best solution to this problem is to verify the calculations by hand.


Thank you in advance.