Excel VBA Iteration

E

Emma Hope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top