kenwarthen@gmail.com
New Member
I'm trying to set up several shortcut keys using the Application.OnKey command in the Workbook.Open event of an Excel 2007 workbook. I'm using the following code, but it is not working. Any suggestions on what I'm doing wrong and how to correct it, would be greatly appreciated.
Application.OnKey "%1", "sNavigateToGroup1"
Application.OnKey "%2", "sNavigateToGroup2"
Application.OnKey "%3", "sNavigateToGroup3"
Application.OnKey "%4", "sNavigateToGroup4"
Application.OnKey "%5", "sNavigateToGroup5"
Application.OnKey "%6", "sNavigateToGroup6"
Application.OnKey "%1", "sNavigateToGroup1"
Application.OnKey "%2", "sNavigateToGroup2"
Application.OnKey "%3", "sNavigateToGroup3"
Application.OnKey "%4", "sNavigateToGroup4"
Application.OnKey "%5", "sNavigateToGroup5"
Application.OnKey "%6", "sNavigateToGroup6"