| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Override Excel's Heroin Addiction to Calculating
If I open a file that includes code (Application.Calculation =
xlCalculationAutomatic) in ThisWorkbookthat changes calc to manual upon opening, it still calculates; likewise, if I use SaveAs in a macro, even if I explicitly change calc to manual first, once it starts saving, it recalculates. How do I stop Excel from calculating when a file is opened and saved? P.S. Am using Excel 2003. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to override a hyperlink | Excel Programming | |||
| Override | Excel Programming | |||
| NosmoQ, good for health, can stop smoking addiction.. | Excel Discussion (Misc queries) | |||
| Override excel's printing dpi setting | Excel Programming | |||
| Override No Zero Values ? | Excel Programming | |||
Threaded Mode
