Default Recalculation Method

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.

-----Original Message-----
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

--
Regards
Roger Govier



.
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top