How to assign Hot-Key to the VBA macro

In the Excel you can open properties of the VBA macro and assign Hot-Key combination to selected procedure.

Does this work with xlCompiler?

Unfortunately - No. xlCompare has no access to this information and doesn't load hot keys.

So, you should use a workaround. Excel allow to setup hotkey programmatically, using VBA macro statements.

Application.OnKey( Key, Procedure) method allows to assign a procedure to the hot-key combination.

We suggest you to add a Workbook_Open event to your workbook and define all hotkeys in one place.

You'll get code like this one:

Private Sub Workbook_Open()
  Application.OnKey "^w", "RebuildCharts"
End Sub

It assigns procedure RebuildCharts to the Strl+w key.

See Also:

More information on the Application.OnKey method