Hi Everyone,
I found a few posts online and I'm hoping you can help me solve this issue.
During the Workbook_Open() Routine, I have the following code:
With Application
.Iteration = True
.MaxIterations = 1000 '<-- or whatever the maximum allowable # you want
.MaxChange = 0.001 '<-- modify as necessary, or remove if desired
End With
During the opening of the workbook, the debugging always errors on the first line. In this case, it would be .Iteration.
My Excel Document is 2007.
Thank you for any help you can provide.
I found a few posts online and I'm hoping you can help me solve this issue.
During the Workbook_Open() Routine, I have the following code:
With Application
.Iteration = True
.MaxIterations = 1000 '<-- or whatever the maximum allowable # you want
.MaxChange = 0.001 '<-- modify as necessary, or remove if desired
End With
During the opening of the workbook, the debugging always errors on the first line. In this case, it would be .Iteration.
My Excel Document is 2007.
Thank you for any help you can provide.