Macro Quick Key

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

Is there a way to assign a macro quick-key to a macro in my personal.xla (XL
2007) file? In other words, if I would hold down Ctrl-F7 for example, then a
particular macro in the .xla file would be executed. Thanks.
 
Is there a way to assign a macro quick-key to a macro in my personal.xla (XL
2007) file?  In other words, if I would hold down Ctrl-F7 for example, then a
particular macro in the .xla file would be executed.  Thanks.
Click to expand...

Mike,

I don't think I posted this correctly, so let me try again.

1. In Excel and close any open workbooks.
2. Open the personal.xla file.
3. Open the Visual Basic Editor.
4. In the VBAProject window, select the workbook for the xla file.
5. In the Properties window, change IsAddin from True to False.
6. Go back to the Excel Window.
7. On the Visual Basic toolbar, press the run macro button.
8. A list of macros should appear. Select the one that you want to
assign the shortcut to.
9. Press the Options Button.
10. Add the shortcut and press OK.
11. Press Cancel.
12. Go back to Visual Basic Editor and make IsAddin True.
13. Close Visual Basic Editor.
14. Close Excel.
15 Save changes to personal.xla file.

Chuck
 
Back
Top