Eric has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
EXCEL AUTOMATIC CALCULATION
Hello,
Thanks in advance for your time.
I do know how to change automatice to manual and vice versa.
But, excel seems to always use "automatic calculation " as a default. I open a new session and it's automatic.
Is there a way to have manual as a default ?
Best regards
Eric
RE: EXCEL AUTOMATIC CALCULATION
Hi Eric,
Thank you for your question.
Open the Visual Basic window and create a new module in the Personal.xls Project.
Create a new macro by typing the following:
---------------------------------------------------
Sub AutoExec()
Application.Calculation = xlManual
End Sub
--------------------------------------------------
Any macro named AutoExec will run automatically when Excel starts.
I hope this answers your question.
Regards
Simon
