I have had the same issues with the debugger. The way I get around this is to use the breakpoints tool, then debug anywhere after any code that calls for another workbook.