malik641
09-23-2005, 03:56 PM
Just a curious question:
In my Workbook_Open Event, I set the calculation to be xlManual and disabled the Recalc Before Save option. In the Workbook_Close Event I reset the values to xlAutomatic and enabled Recalc Before Save.
IF I change ANYTHING in any macro within the workbook, Excel will recalculate all cells if I try to close the application without saving. Why does it recalculate the cells if I didn't do anything to them?
In my Workbook_Open Event, I set the calculation to be xlManual and disabled the Recalc Before Save option. In the Workbook_Close Event I reset the values to xlAutomatic and enabled Recalc Before Save.
IF I change ANYTHING in any macro within the workbook, Excel will recalculate all cells if I try to close the application without saving. Why does it recalculate the cells if I didn't do anything to them?