| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
turning off automatic calculation when loading VBA add-in
Found a solution
ThisWorkbook.Activate Application.Calculation = xlCalculationManual because: You need to have a workbook active before you can set the Calculation property and although it seems counterintuitive, you can "activate" your add-in workbook to serve this purpose even though it's not visible. You need to have a workbook active before you can set the Calculation property and although it seems counterintuitive, you can "activate" your add-in workbook to serve this purpose even though it's not visible. Source:http://www.excelforum.com/archive/in.../t-260962.html Thanks Lars |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| turning off automatic Help | Excel Discussion (Misc queries) | |||
| Turning off automatic mailto: | New Users to Excel | |||
| Turning off all Automatic Formatting in Excel 2003 | Excel Discussion (Misc queries) | |||
| Turning off automatic calculation when opening a CSV file | Excel Programming | |||
| Turning Of Calculation | Excel Programming | |||
Threaded Mode
