Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Assign a shorcut to a non recorded macro (2000 )

    I have a macro that I'd like to assign a shortcut key. I know if I assign the macro to a button and use text labels, I can assign an Alt+letter shortcut to the button. This method is not viable due to space limitations. Is it possible to assign the shortcut to a non-recorded macro?

    If there is no way to assign the shortcut after creation, I guess I could record a dummy macro and them replace the dummy code with the actual code.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Assign a shorcut to a non recorded macro (2000 )

    Select Tools | Macro | Macros... or press Alt+F8.
    Select the macro in the list.
    Click the Options button.
    Assign a shortcut key, then OK your way out.

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Assign a shorcut to a non recorded macro (2000

    Thanks Hans.

    Follow up question/issue. I used the technique for a macro stored in the personal.xls and it doesn't "stick". It launches a macro if I do it for other workbooks, but not the personal.xls. Can a shortcut be assigned to a personal.xls macro?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Assign a shorcut to a non recorded macro (2000

    > Can a shortcut be assigned to a personal.xls macro?

    Yes, definitely. When you have assigned a shortcut key to a macro in Personal.xls, and then quit Excel, it should ask you whether you want to save changes to Personal.xls. If you click Yes, the shortcut key should still be available next time you start Excel.

    If not, an add-in may be interfering - check out Jan Karel Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

Posting Permissions

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