Defined Name Box Shortcut
Excel provides many shortcut keys,
but one that is sorely missing is a shortcut to the Name Box on the formula
bar. However, you can use the following macro to set the focus to the
defined name box. Assign a shortcut keystroke to the following macro
(I use CTRL+SHIFT+N).
Public Declare Function SetFocus Lib "user32" (ByVal hwnd As Long) As Long
Public Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Public Declare Function FindWindowEx Lib "user32" Alias "FindWindowExA" _
(ByVal hWnd1 As Long, ByVal hWnd2 As Long, _
ByVal lpsz1 As String, ByVal lpsz2 As String) As Long
This code has been tested and it does work in Excel 2007.
On a related note, you may find it annoying that the Name Box only the first 16 or so characters of a defined name. This may cause long and similar names to appear the same in the Name Box. As a remedy to this dilemma, you can widen the Name Box when it drops down by using the code here.