Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disc full, saved to temp. file | Excel Discussion (Misc queries) | |||
Pasword protected Excel file encrypted, how do I read this file? | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel | |||
cannot open excel file, please help!!! | Excel Discussion (Misc queries) |