O
O_lanke
Hi!
I have a problem regarding an add-in:
I'm trying to set "iteration" in a workbook_open event with the code:
Private Sub Workbook_Open()
With Application
.Iteration = True
.MaxIterations = 500
.MaxChange = 0.001
End With
But I get the error message
"Error 1014, Method 'iteration'of object application failed' when
Excel is started and loads the add-in
My Excel does not have iteration ticked off as default in the
tools/options/calculation. But why can not this be done with VB upon
start of Excel ?
If the add-in is loaded after Excel have been started, the
workbook_open event works ok, and the iteration is set.
Any suggestions ?
I have a problem regarding an add-in:
I'm trying to set "iteration" in a workbook_open event with the code:
Private Sub Workbook_Open()
With Application
.Iteration = True
.MaxIterations = 500
.MaxChange = 0.001
End With
But I get the error message
"Error 1014, Method 'iteration'of object application failed' when
Excel is started and loads the add-in
My Excel does not have iteration ticked off as default in the
tools/options/calculation. But why can not this be done with VB upon
start of Excel ?
If the add-in is loaded after Excel have been started, the
workbook_open event works ok, and the iteration is set.
Any suggestions ?