Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: assigning shortcut keys

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi I have the following line of code in my
    Macro:

    Application.OnKey "^9", "myMac"

    After running the macro the first time, it will assign to the key stroke "CNTRL+9" the operation of running the macro myMac. It works fine, but after closing the excel file and opening it back up. The "CNTRL+9" key stroke combination does not run myMac.

    Does anyone know what I can do to make it so that once you assign an operation to a keystroke, it will work even after you close and open the excel file?


    Thanks

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Sackville
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    At the end of your formula, add +N(" your comments"). Anything which appears inside of the quote marks will be assigned the value of zero. When you edit a formula, you can see the comments within the formula.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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