+ Reply to Thread
Results 1 to 2 of 2

How to add hot-key to .xla file in VBA Editor

  1. #1
    Dennis
    Guest

    How to add hot-key to .xla file in VBA Editor

    Using 2003

    I would like to add a keyboard short-cut to a macro in an .xla file.

    Of course, I tried it in Excel but .xla macros do not show up in the
    dropdown box.

    Is there a better/shorter way than saving the .xla file to .xls file
    applying the shortcut then re-saving as an .xla file etc.

    Thanks

    Dennis

  2. #2
    Gord Dibben
    Guest

    Re: How to add hot-key to .xla file in VBA Editor

    In Excel go to Tools>Macro>Macros and just type in the name of the macro.

    You can then hit "Options" and give it a shortcut key.

    For added info on your last question, macros in add-ins can be edited in the VBE
    directly.

    And you don't have to save the *.xla file to *.xls file then re-save as *.xla
    if you needed to see/edit data on worksheets or add sheets.

    In VBE select your workbook/project the expand and select Thisworkbook and
    View>Properties Window.

    Change "IsAddin" to False

    Make your changes then change back to True



    Gord Dibben MS Excel MVP

    On Fri, 30 Jun 2006 10:20:01 -0700, Dennis <Dennis@discussions.microsoft.com>
    wrote:

    >Using 2003
    >
    >I would like to add a keyboard short-cut to a macro in an .xla file.
    >
    >Of course, I tried it in Excel but .xla macros do not show up in the
    >dropdown box.
    >
    >Is there a better/shorter way than saving the .xla file to .xls file
    >applying the shortcut then re-saving as an .xla file etc.
    >
    >Thanks
    >
    >Dennis



+ 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