This project has moved and is read-only. For the latest updates, please go here.

Adding a keyboard shortcut

You can register a shortcut key for your macro in your AutoOpen.

<DnaLibrary Name="Test OnKey" Language="C#"> 
using ExcelDna.Integration; 
public class TestOnKey : IExcelAddIn 
    public void AutoOpen() 
        // Register Ctrl+Shift+H to call SayHello 
        XlCall.Excel(XlCall.xlcOnKey, "^H", "SayHello"); 
    public void AutoClose() 
        // Clear the registration if the add-in is unloaded 
        XlCall.Excel(XlCall.xlcOnKey, "^H"); 
    [ExcelCommand(MenuText = "Say Hello")] 
    public static void SayHello() 
            XlCall.Excel(XlCall.xlcAlert, "Hello there!"); 


This can also be done with the COM interface, using Application.OnKey.

Last edited Jun 5, 2012 at 9:04 PM by govert, version 2