it is default set to manual, and calculation is done by my macro. everything
is fine. However, my workbook will be mess up and start calculate everything
when user forget to close my workbook and open another workbook. I guess it
is because the other workbooks default is automatic and it change my working
environment background to automatic. How can I prevent my workbook calculate
itself when another wookbook is open?