P
Paige
Here's the screnario: Only 1 file is open; it has formulas, but they have
all been calculated. There is no before_save (or before_close) code. When I
do file/save from the menu (and also from VB), Excel does not do a
recalculation; however, when I do file/save as from the menu (and also if I
do it from VB and even if I use Application.Calculation = xlCalculationManual
before the saveas command), it does a recalculation. 3 questions:
1) Why does it act differently between file/save and file save as?
2) Why is my Application.Calculation = xlCalculationManual command being
ignored?
3) How can I force it to NOT recalculate during saveas?
all been calculated. There is no before_save (or before_close) code. When I
do file/save from the menu (and also from VB), Excel does not do a
recalculation; however, when I do file/save as from the menu (and also if I
do it from VB and even if I use Application.Calculation = xlCalculationManual
before the saveas command), it does a recalculation. 3 questions:
1) Why does it act differently between file/save and file save as?
2) Why is my Application.Calculation = xlCalculationManual command being
ignored?
3) How can I force it to NOT recalculate during saveas?