![]() |
|
|
|
#1
|
|||
|
|||
|
If you want a specific workbook to open with calculation set to manual, create this sub in the workbook:
Sub Auto_Open() Application.Calculation = xlManual End Sub It automatically runs when you open the workbook, and sets calculation to manual. If you want excel to always open with calculation turned off, create personal.xlsb, save it in the correct folder and put the sub in it. You can look up how to setup and use personal.xlsb on the web. I'm not sure why you would set calculation to manual as the default, though. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| force formula calc to manual when opening any workbook | johnd23 | Excel | 1 | 02-27-2017 08:22 PM |
| Perform calc in active cell then highlight based on formula result | grexcelman | Excel Programming | 4 | 01-12-2015 11:00 AM |
Trying to create a formula to calc if I add x new accounts, I will have to hire y tech/support ppl
|
glen123 | Excel | 7 | 07-28-2014 07:29 AM |
| Problem opening Workbook with WORD VBA | buncs | Word VBA | 0 | 01-14-2014 07:16 PM |
#REF! error when opening a workbook that contain a refference to another workbook
|
tanababa | Excel | 2 | 06-07-2012 03:11 PM |