+ Reply to Thread
Results 1 to 3 of 3

Macro stops when I run it with key shortcut

  1. #1
    Registered User
    Join Date
    05-24-2023
    Location
    Budapest, Hungary
    MS-Off Ver
    365
    Posts
    6

    Macro stops when I run it with key shortcut

    Hi,
    I have a macro in table1 that contains Workbooks.Open methods (maybe this is the reason of my issue) and when I run it with key shortcut (CTRL+SHIFT+R) it stops right after the opening of the first workbook (table2). When I run it from the editor it runs well.
    Can you help me, how I should fix this problem?

    table1.xlsm
    table2.xlsx
    table3.xlsx

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Macro stops when I run it with key shortcut

    Use a keyboard shortcut that does not involve the shift key. This is a longstanding bug.
    Rory

  3. #3
    Registered User
    Join Date
    05-24-2023
    Location
    Budapest, Hungary
    MS-Off Ver
    365
    Posts
    6

    Re: Macro stops when I run it with key shortcut

    Thank you very much!

+ 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. Macro that stops at last row of value
    By excel1jennifer0 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-11-2023, 09:33 AM
  2. Replies: 2
    Last Post: 11-17-2015, 02:34 PM
  3. Refresh macro stops working when combined with another macro
    By Spaaacce in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2015, 04:06 PM
  4. Macro that runs when ran from Macro menu, but stops when using short cut keys...
    By Joven76 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-12-2014, 02:29 PM
  5. Macro stops at colleague but not with me
    By DKAbi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-30-2013, 05:20 PM
  6. Macro stops in an odd place
    By DKAbi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-14-2013, 05:20 PM
  7. My Macro stops
    By Bobby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2006, 03:10 PM

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