+ Reply to Thread
Results 1 to 3 of 3

Key combination won't run my macro.

  1. #1
    Registered User
    Join Date
    12-09-2011
    Location
    Arkansas, US
    MS-Off Ver
    Excel 2003
    Posts
    3

    Key combination won't run my macro.

    I have created a macro and have tried to assigned the key combination to Ctrl+Shift+p via the macro options window. The macro runs just fine if I hit "Run" in the macro window or run it from the VBA editor. I have other macros in my workbook that run when I click a button, but setting a key combination is not working. When I try to set the macro to just Ctrl+p, it does not reassign this to my macro (It still displays the "Print" window.). I have set my macro security to "Enable all macros." Am I missing an option that prevents key combo reassignment?

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Key combination won't run my macro.

    Hi Galvax,

    Your key macro should be just a wrapper - use it to call your macro.

    Please Login or Register  to view this content.
    is this what you're doing?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    07-12-2012
    Location
    New Hampshire, United States
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Key combination won't run my macro.

    This site should be useful: http://nhprague.blogspot.com/2012/03...-keyboard.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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