+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    02-01-2014
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2013
    Posts
    4

    Question 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???
    Last edited by davesexcel; 10-19-2020 at 12:36 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,264

    Re: Cant copy/paste from workbook when using 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.

  3. #3
    Registered User
    Join Date
    02-01-2014
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2013
    Posts
    4

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

    Also cross posted to vbforums, but it won't let me post the link in the message:
    Last edited by Dr PE; 10-19-2020 at 03:27 PM.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,264

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

    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.

  5. #5
    Registered User
    Join Date
    02-01-2014
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2013
    Posts
    4

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

    That is very interesting. I didn't know that it could tell cut/paste from typing manually. A character is a character, right? But I am all for preventing spammers. If this is all it takes, I am happy to comply.

    I tried to "type out the link" as you requested without copying and pasting, but it still recognized it as a URL and rejected it.

    The link is showthread.php?889052-Cant-copy-paste-from-workbook-when-using-shortcut-hot-key

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 04-25-2019, 08:00 PM
  2. COPY/ PASTE VALUE keyboard shortcut
    By vlady in forum Excel Tips
    Replies: 4
    Last Post: 10-06-2018, 04:40 PM
  3. Replies: 1
    Last Post: 06-01-2018, 10:08 AM
  4. [SOLVED] Create a keyboard shortcut through Macro in order to copy paste special (divide)
    By greywarden in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2017, 10:48 AM
  5. ShortCut key - Copy and and Paste Filtered Data
    By jagadeesh.rt in forum Excel General
    Replies: 3
    Last Post: 01-16-2015, 03:11 AM
  6. Keyboard shortcut for "copy paste special values?"
    By Star AJ in forum Excel General
    Replies: 4
    Last Post: 03-19-2014, 06:34 AM
  7. Copy and paste non consecutive cells and paste consecutively in another workbook
    By macquhele in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2011, 02:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1