Excel Macro does not complete with shortcut key.

[CJPHX]

Mornign All,
I am spending my Saturday morning writing more macro's to streamline reporting processes. I have a macro I created that opens Access runs a query I have in there and then exports that to excel moves it to the report I need and organizes itself. The problem I am have is if I am in the VBE and step into line by line it does fine. If I just run the macro it runs fine but when I use the shortcute keys no matter which ones I assign to it it stops after it opens the workbook I need.

Please Login or Register  to view this content.

This is where it stops if I use the shortcut keys. It opens the file and then thats it. However, if I just use run or stepinto line by line it continues on.

Please Login or Register  to view this content.

[romperstomper]

Are you using a shortcut that involves the Shift key?

[CJPHX]

Yeah, I was using CTRL + SHIFT + P.

[romperstomper]

Try a shortcut that does not involve the shift key. Should be OK then (it relates to holding Shift down when opening a workbook to prevent code from firing).

[CJPHX]

Thank you romper. I had never even thought of that. As soon as I changed it to not using the SHIFT key it worked perfectly.