View Single Post
 
Old 03-31-2017, 02:29 PM
Steve_B Steve_B is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jul 2013
Posts: 7
Steve_B is on a distinguished road
Default

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.
Reply With Quote