I'm currently working on a macro that is embedded in an ".xla" file. I have created a short cut key (ctrl+shift+ K) that executes this macro. However, there is one line of code in the macro where the code stops every time I run it.

Here is the code:

Workbooks.Open (TEMPLATE_FILEPATH & "\" & NAME_WKBK)

This line of code opens a workbook that contains data that I need to access when this macro is run. The variable: TEMPLATE_FILEPATH contains the file path information & NAME_WKBK contains the name of the workbook.

When I put a breakpoint in the VB editor on this line of code, the code stops there and I can press the "F8" key and then press play and the code will run normally without a problem. However if I don't include a breakpoint, but put a breakpoint on the next subsequent line of code the compiler never makes it past the above line of code.

The really funny thing about this problem is that if I change the short cut key to "ctrl k" the entire script executes without a problem. For some reason when I am using the open file method and "shift" in the short cut key, the macro does not run all the way through. Can somebody help? If you need a better explanation I would be willing to give one.