Macro that runs when ran from Macro menu, but stops when using short cut keys...

Hello all,

I'm having an issue with a macro that I cannot seem to figure out why it isn't working properly. If I go to the view macro menu and run it from there, it works just fine, every time. While I was building it, I set a short cut key (Ctrl+Shift+L) to run it. It gets to a certain point and just stops. No error messages, just stops.

I'm having the macro open another spreadsheet to pull information from. When ran from the menu, it opens the file just fine and continues on with the macro. When ran from the short cut key however, it opens the file then just stops.. Oh, I feel I must mention that once the file is open, it reactivates the main window and continues from there. But as I said, when running from the short cut key, it opens the file and just stops.

Any idea why this happens?

Let me know if you need to see the code.

Please Login or Register  to view this content.

It stops right after

Please Login or Register  to view this content.

I've only copied the beginning section of the code. Let me know if you need all of it.

Oh, on another note. I've tried moving the "Workbooks.Open" code to a different section of the macro (just before the macro needs the information from the other workbook) and I still get the same result, works fine up to that section, opens the workbook and then just stops, but if I run it from the view macro menu, the entire macro works fine.

Yes to both a and b... I agree, very odd that it runs fine directly and not the short cut. It also works fine when stepping through the code using F8, but not when running from the short cut.

Very odd indeed.

Unfortunately no. Even tried a different shortcut key. Same result.

I'll give it a shot...

Don't ask me why, but that worked. I don't usually hold the shift key down for a long period of time when I activate a macro, but I changed it to a non-shift keyboard shortcut and it worked!

Really weird!!!