Hello everyone,
I lose a random option on my automatic posts in Excel 2003. I tried to insert a macro in the Open personal.xls but without success, and as I am novice in VBA ...
Someone there had this problem?
Printable View
Hello everyone,
I lose a random option on my automatic posts in Excel 2003. I tried to insert a macro in the Open personal.xls but without success, and as I am novice in VBA ...
Someone there had this problem?
Can you be a little more explicit? Not obvious to help solve this problem with so little information ...
Is not the code that you inserted in your procedure that is involved:
To switch to manual calculation
With Application
.Calculation = xlManual
to return to automatic calculation (eg end of treatment)
With Application
.Calculation = xlAutomatic
Hello and thank you for your response!
That's what happens:
In Excel 2003, I validate that the option "Automatic calculation". I open a file xl. I control the method of calculation (tools/options/calculation ...) if the manual mode is activated, I validate the automatic mode. I'm, I close excel, I re-open Excel and then the same file ... and it is in manual calculation mode or "on order" enabled! This occurs regardless of the files but only in Excel 2003.
hoping to have been more clear ...
In Options >> Calculation: Iteration mode is checked? If so uncheck it.