Cntl+. macro ?

[fb7894]

Is there any way to assign a macro shortcut key of Cntl+period ?

[Paul_Hossler]

In the ThisWorkbook code module



Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "^."
End Sub

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