<div>
This my attempt.........<br />
<br />

<pre><code id="code-20-38178459-1">'Private Sub Workbook_BeforeClose(Cancel As Boolean)
'With Application
'.CalculateBeforeSave = False
'.Calculation = xlAutomatic
'.MaxChange = 0.001
'End With
'MsgBox &quot;Automatic Calculation has been &quot;&quot;enabled&quot;&quot;.&quot;
'
'End Sub</code></pre>
</div>


This my attempt.........



'Private Sub Workbook_BeforeClose(Cancel As Boolean)
'With Application
'.CalculateBeforeSave = False
'.Calculation = xlAutomatic
'.MaxChange = 0.001
'End With
'MsgBox "Automatic Calculation has been ""enabled""."
'
'End Sub

<div>
many thanks for the feed back...
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts <br />
<br />
Need a macro to switch on the auto cal funtion in excel 2003 once the user opens up the workbook....<br />
<br />
I have set the auto cal to manual via the Tool&gt;Option in excel - due to the size of the calulcation taking place in to whole workbook.....<br />
<br />
so need a macro each time workbook is open to siwtch on auto cal and turn of auto cal when workbook is closed down.....
</div>
</div>


Hi Experts 

Need a macro to switch on the auto cal funtion in excel 2003 once the user opens up the workbook....

I have set the auto cal to manual via the Tool>Option in excel - due to the size of the calulcation taking place in to whole workbook.....

so need a macro each time workbook is open to siwtch on auto cal and turn of auto cal when workbook is closed down.....

macro to switch on auto cals when workbook is opened

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.