E
Eric S
Can anyone tell me how to set Excel so that when any
worksheet is opened, the calculation method is set to
manual.
worksheet is opened, the calculation method is set to
manual.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Govier
Hi Eric
One way would be to set a macro in the Workbook Open event
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
Right Click on a Sheet Tab of the Workbook
Choose View Code
Double Click on ThisWorkbook and paste the macro into the right hand pane
Save the Workbook
Now, whenever you open that workbook, calculation will be set to manual
One way would be to set a macro in the Workbook Open event
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
Right Click on a Sheet Tab of the Workbook
Choose View Code
Double Click on ThisWorkbook and paste the macro into the right hand pane
Save the Workbook
Now, whenever you open that workbook, calculation will be set to manual
E
Eric S
Is there any way so that all worksheets opened and created
are set to manual recalc? I would think there is a
registry setting to do this.
are set to manual recalc? I would think there is a
registry setting to do this.
G
Gord Dibben
Eric
Excel takes the Calc mode of the first workbook opened during a session.
There is no registry setting to control this.
I would suggest sticking Roger's code into your Personal.xls which opens first
when you start Excel.
Gord Dibben Excel MVP
Excel takes the Calc mode of the first workbook opened during a session.
There is no registry setting to control this.
I would suggest sticking Roger's code into your Personal.xls which opens first
when you start Excel.
Gord Dibben Excel MVP