Is there any way to assign a macro shortcut key of Cntl+period ?
Printable View
Is there any way to assign a macro shortcut key of Cntl+period ?
In the ThisWorkbook code module
Code:Option Explicit
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.OnKey "^."
End Sub
Private Sub Workbook_Open()
Application.OnKey "^.", "Hello"
End Sub