Excel- enter/tab choosing locked cell on sheet

[westconn1]

as the combobox never goes to H3 the code for combobox keypress is never called you would need to add code in selectionchange event
try this change

On Error GoTo errHandler
 
'If Target.Count > 1 Then GoTo exitHandler-- why did this kill it for me?
If Target.Address = "$H$4" Then Range("d12").Activate: Exit Sub
  Set cboTemp = ws.OLEObjects("TempCombo")
    On Error Resume Next

the double tab effect is because cells in cols e and f are not locked so can be selected under the combobox