Automatically calculate formulas when workbook opens

[noora19]

My excel resets to the manual feature for calculating formulas everytime I close out of excel completely and I need to reset this feature each time. How do I develop a macro that automatically sets the application to 'automatic' (from manual) when I open up excel. I think the code needs to be in my "personal" VMA excel object in order to activate the event ('open') instead of a module. Is this correct? This is the code I was trying to use (but I am getting an error as soon as I open excel):

Private Sub Workbook_Open()
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
<o> </o>
If Application.Calculation = -xlCalculationManual = True Then
With Application
.Calculation = xlCalculationAutomatic
.MaxChange = 0.001
End With
<o></o>
Else
End
<o> </o>
End If
End Sub


I found some code online that was using the 'Public User Setting" in conjunction with similar codes. What is the Public User Setting used for?

Any info appreciated!

Thanks

 

[jim may]

Remove RED characters..(They produce no benefit)..

Private Sub Workbook_Open()

If Application.Calculation = -xlCalculationManual = True Then
With Application
.Calculation = xlCalculationAutomatic
.MaxChange = 0.001
End With

Else
End
End If
End Sub