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

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

In Excel go to ToolsMacroMacros 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
ViewProperties 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
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