Install VBA Reference Library causes Can't enter break mode

So I have this XLSM and there is code which installs a reference to another open XLSM workbook.

However as soon as the code reaches the line to "AddFromFile", a message box appears: "Can't enter break mode at this time"

Selecting the Continue button allows the code to keep running but any debug.assert and any break points after this line are ignored!

Can anyone let me know how to continue to allow debugging after I add a reference?


I googled and found similar problems which were solved by Norie & Rory. See links below.

http://www.mrexcel.com/forum/excel-q...ode-error.html

http://www.ozgrid.com/forum/showthread.php?t=152478

But one solved it by early binding, the other by late binding?!?

And how do I do early or late bind the addfromfile on an excel workbook?

My Add Reference function below if it helps solve it.

Please Login or Register  to view this content.

In the end, I gave up and went back to Application.Run