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

[Guest]

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

 

[Gord Dibben]

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