Quote Originally Posted by mdmackillop
Be wary about turning you calculations off. If you code bombs out, there is nothing to reset it to automatic, which can cause problems if you don't notice.
Malcolm, the only code I have in personal is to set calculations to on when any workbook is opened and it is for the very reason you cite.