Results 1 to 9 of 9

Macro run by shortcut key malfunctions

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-15-2010
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2003
    Posts
    538

    Macro run by shortcut key malfunctions

    If I run Sub pmOpenIt() from F5 key, fine. From alt-F8 and run, fine. I can even type call pmOpenIt() into debug window and run, fine.

    But using its option-set Ctrl-Shift-Q causes it to run through the Workbooks.Open, and no further.

    So that I can rule out corruption, can someone reproduce? It chokes in XL2003 and XL2007 here
    Option Explicit
    Sub pmOpenIt()
        Application.StatusBar = "running"
        Debug.Print "0 "
        Workbooks.Open "c:\delme.xls", 0
        Debug.Print "1 "
        Application.StatusBar = "Done."
    End Sub
    Last edited by Oppressed1; 10-15-2013 at 08:11 PM. Reason: Removed superfluous/confusing extra word "open"; changed Ctrl-Alt-Q to Ctrl-Shift-Q
    Chip, if you can read this, you're STILL making the world a better place with your immeasurably valuable gifts. Every week, you continue to help me (and untold numbers of others) tremendously. Practically no alternative outlets can match your effectiveness, even over the vast number of topics you demystify and empower usage of. You were, and still are, amazing.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 06-09-2013, 07:21 PM
  2. [SOLVED] OpenFileDialog box malfunctions
    By hometech in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2012, 03:18 AM
  3. Responses hampered by site malfunctions...??
    By HuskerBronco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2008, 11:55 AM
  4. Workbook only malfunctions on a single PC
    By Crypto in forum Excel General
    Replies: 3
    Last Post: 01-10-2006, 07:55 PM
  5. Macro shortcutsWhen you are assigning a keyboard shortcut to a macro?
    By JudithJubilee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2005, 04:06 AM

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