Cant copy/paste from workbook when using shortcut/hot key

I have encountered a very strange problem. I have some code that opens a second workbook, copies a sheet from the second workbook into the first workbook (where the VBA is), then closes the second workbook. It works fine if I run it from the code window, or by using View Macros. However, if I try to run it using an assigned Shortcut/Hot Key (CTRL+J ir CTRK+M), it will open the second workbook then hang. It won't do the copy or close the workbook. I have tried 4 different ways of doing the copy/paste (cells.select, selection.copy, ActiveSheet.copy, and the following code). All of them behave the same way - they work but not with the shortcut/hot key

Please Login or Register  to view this content.

Why is there a difference when running this from a shortcut/hot key???

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

Crossposted Sites: https://www.mrexcel.com/board/thread...t-key.1148800/
https://www.ozgrid.com/forum/index.p...rtcut-hot-key/

If there are any other sites you have posted to, please add them to this thread.

Also cross posted to vbforums, but it won't let me post the link in the message:

Also cross posted to vbforums, but it won't let me post the link in the message:

That is by design to prevent spammers. You need to have a minimum number of posts to do that. You should type out the link instead of copying and pasting. This is important if you understand the rationale explained in the link I provided.

Please amend your post to include that link.