Shortcuts for VBA defined macros do not work

Discussion in 'Windows 7 Help and Support' started by cfhuckmg, Oct 18, 2011.

  1. cfhuckmg

    cfhuckmg New Member

    Joined:
    Oct 17, 2011
    Messages:
    6
    Likes Received:
    0
    • Can’t get shortcuts to call up certain macros. All macro’s can be executed from Menu>Developer>Macros. Shortcuts for simple insert commands such as date & time are okay!! Shortcuts for simple VBA-defined macros do not work!!. Is there an option that needs to be set?

      Chuck
      Win 7 x64 SP1
     
  2. zvit

    zvit Honorable Member

    Joined:
    Nov 3, 2009
    Messages:
    2,455
    Likes Received:
    84
    What program are you using VBA in? Access, Excel... etc

    Also, please post your macro code here.
     
  3. cfhuckmg

    cfhuckmg New Member

    Joined:
    Oct 17, 2011
    Messages:
    6
    Likes Received:
    0
    Hi Zvit,

    Using Word 2007. Will post the code below but this is generic for all VBA-defined macros.

    You must be some kind of wizard!! It hasn't worked for months, but thought I'd give it another try before sending this off. Now it works!! Thanks.

    Chuck
     
  4. zvit

    zvit Honorable Member

    Joined:
    Nov 3, 2009
    Messages:
    2,455
    Likes Received:
    84
    I doubt I'm a wizard since I didn't even start helping yet... but I like the wizard title! :)
     

Share This Page

Loading...