error 1004: method 'iteration' of object '_application' failed

[juliadeclared]

Hi,
I've never used macros before, so attempting to debug this thing is like learning a new language. I got the following error when trying to open a document:

1004: method 'iteration' of object '_application' failed

When I attempt to debug, I get this code:

Private Sub Workbook_Open()​

​

Application.Iteration = True​

​

Call BuildBar(ThisWorkbook.Name + " TB")​

Call RebootModel​

​

Sheet9.Activate​

​

End Sub
​

With "Application.Iteration = True" highlighted. I'm not exactly sure what it all means. Only thing i found online about this, says to try this:

With Application​

If Not .Iteration Then .Iteration = True​

End With​

But I have no idea where to put it. I've tried it like so:

Private Sub Workbook_Open()​

​

Application.Iteration = True​

​

Call BuildBar(ThisWorkbook.Name + " TB")​

Call RebootModel​

​

Sheet9.Activate​

​

With Application​

If Not .Iteration Then .Iteration = True​

End With​

​

End Sub

​

But it gives me the following error when I try to run it:

Run-time error '1004':
application-defined or object-defined error

​

What should I do?! Please help.

 

[Trevor G]

Welcome to the forum, change it like this:

Private Sub Workbook_Open()
With Application
If Not .Iteration Then .Iteration = True
End With
Call BuildBar(ThisWorkbook.Name + " TB")
Call RebootModel
Sheet9.Activate
End Sub