Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Workbook Calculation
I want to set the calculation option for my ActiveWorkbook to Manual. How do
I accomplish that without using the code below which set the option for all open workbooks? Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Workbook Calculation
There is no simple way to do this because Excel does not have a
Workbook.Calculate method. The more complex way of achieveing something like this (which I use in my commercial FastExcel product) is to use an Application level event to switch Worksheet.EnableCalculation off for all the sheets in all the inactive workbooks, and switch Worksheet.EnableCalculation on for all the sheets in the activeworkbook. Note that the EnableCalculation property is not saved with a workbook. Then you would also need a routine to handle manual calculation of the disabled workbooks etc etc. regards Charles ___________________________________ The Excel Calculation Site http://www.decisionmodels.com "Ayo" wrote in message ... I want to set the calculation option for my ActiveWorkbook to Manual. How do I accomplish that without using the code below which set the option for all open workbooks? Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook causes calculation errors | Excel Worksheet Functions | |||
Which workbook caused calculation | Excel Programming | |||
Calculation speed and workbook size | Excel Discussion (Misc queries) | |||
Quantifying Calculation Steps in a Workbook | Excel Discussion (Misc queries) | |||
Non-calculation in large workbook | Excel Discussion (Misc queries) |