Workbook_Open Not Working In ThisWorkbook

[cicconmr]

Let me know if I'm doing this correctly.

I'm double clicking the ThisWorkbook under Excel Object and adding in:

Private Sub Workbook_Open()

Call Sort

End Sub

That's it....can it have something to do with the way I saved my program? This should be working....right?

 

[Andrew Poulsom]

I'll this code however, in the mean time what is the "OnTime" method and how does that work?

Try (for 10 seconds):

Private Sub Workbook_Open()
    Application.OnTime Now + TimeValue("00:00:10"), "Organize_Macro"
End Sub

 

[cicconmr]

Note to all:

OnTime works, it allows your BB links to reload. I will say that I could not run my subroutine until I took it out of "ThisWorkbook" and moved it into a module. I'm assuming that is how the Application.OnTime searches for your Macro, but I don't really know that. Regardless....make sure that the Macro you are calling is in a Module, not only in "ThisWorkbook"

Thank you all for all your help!

Matt