Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
turn off/on automatic calc upon open/close workbook?
I am giving up on my code ... it runs so damned slow with auto calc on and I
just don't know why. With calc set to manual and calc calls within the code, all runs well. So ... Could someone please tell me how I can turn calc to manual upon opening my workbook and then turn it back to auto upon closing? I need the user to find it seemless and not a hassle. TIA WD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
turn off/on automatic calc upon open/close workbook?
Application.Calculation = xlCalculationManual
Application.Calculation = xlCalculationAutomatic Die_Another_Day wdeleo wrote: I am giving up on my code ... it runs so damned slow with auto calc on and I just don't know why. With calc set to manual and calc calls within the code, all runs well. So ... Could someone please tell me how I can turn calc to manual upon opening my workbook and then turn it back to auto upon closing? I need the user to find it seemless and not a hassle. TIA WD |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
turn off/on automatic calc upon open/close workbook?
Great, but how do I go about running that line of script upon opening the
workbook? How do I tell Excel to use manual calc for ONLY this workbook? What if the user has another workbook open at the same time? Thanks "Die_Another_Day" wrote: Application.Calculation = xlCalculationManual Application.Calculation = xlCalculationAutomatic Die_Another_Day wdeleo wrote: I am giving up on my code ... it runs so damned slow with auto calc on and I just don't know why. With calc set to manual and calc calls within the code, all runs well. So ... Could someone please tell me how I can turn calc to manual upon opening my workbook and then turn it back to auto upon closing? I need the user to find it seemless and not a hassle. TIA WD |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
turn off/on automatic calc upon open/close workbook?
Application.Calculation, by definition, is an application-wide setting, so
will affect all open workbooks. If that is a problem, just switch to manual whilst your code is running: With Application .Calculation = xlCalculationManual 'Your Code .Calculation = xlCalculationAutomatic End With NickHK "wdeleo" wrote in message ... Great, but how do I go about running that line of script upon opening the workbook? How do I tell Excel to use manual calc for ONLY this workbook? What if the user has another workbook open at the same time? Thanks "Die_Another_Day" wrote: Application.Calculation = xlCalculationManual Application.Calculation = xlCalculationAutomatic Die_Another_Day wdeleo wrote: I am giving up on my code ... it runs so damned slow with auto calc on and I just don't know why. With calc set to manual and calc calls within the code, all runs well. So ... Could someone please tell me how I can turn calc to manual upon opening my workbook and then turn it back to auto upon closing? I need the user to find it seemless and not a hassle. TIA WD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn automatic Calc: off, script? | Excel Discussion (Misc queries) | |||
Calc status of open excel workbook should not overwrite another | Setting up and Configuration of Excel | |||
Before close and workbook open! | Excel Programming | |||
Turn Off Macros With Workbook Open | Excel Programming | |||
Close Open Workbook | Excel Programming |