Excel VBA Iteration
 

On my spreadsheet i have a circular reference, i need this circular formula
however the message telling me i have one is confusing my users when they
open the spreadsheet.

I have figured out that turning on iteration fixes the error message, so i
wish to use VBA to turn on iteration when opening the workbook. Logically
this should work shouldn't it?

Private Sub Workbook_Open()
Application.Iteration = True
End Sub

but the error message still comes up and then it turns the iteration on. So
i thought maybe if i turned off auto calculation and then back on after i.e.

Private Sub Workbook_Open()
Application.Calculation = xlManual
Application.Iteration = True
Application.Calculation = xlAutomatic
End Sub

And again, the error message comes up and then it turns off the calc, turns
on the iteration and so on.....

I have tried this sub on each worksheet and in a module, it doesn't work.
Please can someone tell me how to make this work.

Thanks

Excel VBA Iteration
 

Try 'Application.DisplayAlerts = False'.

"Emma Hope" wrote:


On my spreadsheet i have a circular reference, i need this circular formula
however the message telling me i have one is confusing my users when they
open the spreadsheet.

I have figured out that turning on iteration fixes the error message, so i
wish to use VBA to turn on iteration when opening the workbook. Logically
this should work shouldn't it?

Private Sub Workbook_Open()
Application.Iteration = True
End Sub

but the error message still comes up and then it turns the iteration on. So
i thought maybe if i turned off auto calculation and then back on after i.e.

Private Sub Workbook_Open()
Application.Calculation = xlManual
Application.Iteration = True
Application.Calculation = xlAutomatic
End Sub

And again, the error message comes up and then it turns off the calc, turns
on the iteration and so on.....

I have tried this sub on each worksheet and in a module, it doesn't work.
Please can someone tell me how to make this work.

Thanks