Opening Workbook causes code to stop...

[Centrican]

I've got an interesting problem: my code is opening a workbook, and until today did this no problem. Today the format of the workbook changed so I made modifications to my code; but now the file that is opened appears to cause the code to end.

There is no code within the target workbook, so it's not running anything and stopping that way.

It opens the file, but it does not then reach the next line of code, even if I add multiple break points.


Anyone ever seen anything similar, or have any ideas what may be happening?

 

[MrKowz]

Can you please post the code so we can see where it might be bugging?

 

[Jonmo1]

I have seen the problem, and I may know the cause, but not sure of the resolution.

When the problem occurs, in the book that was opened...
Check to see if it is in "Design Mode"

That will be on the "Control Toolbox" toolbar.
The top left button, if you hover your mouse on it, does it say
"Design Mode"
or
"Exit Design Mode"

 

[Centrican]

Not a bad suggestion; but it wasn't that.

I managed to get the file to open and not exit the code, but it was by closing other excel files I had open. Not sure why that was causing a problem, but at least I have a solution...