Call VBA macro with a hotkey
Compilation and Protection options and features
Excel specific questions
Error messages, bugreports
In the Excel you can open properties of the VBA macro and assign Hot-Key combination to selected procedure.
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"
It assigns procedure RebuildCharts to the Strl+w key.