title: Combobox drop down showing up in other sheets
body: <p>I have a combo box drop down with search suggestions, made from code here:</p>
  
  <p><a href="http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/" rel="nofollow noreferrer">http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/</a></p>
  
  <p>It works very well, but when I'm on another sheet and pressing "Enter", the search field randomly pops up in the sheet<a href="https://i.stack.imgur.com/zPLbw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zPLbw.png" alt="enter image description here"></a></p>
  
  <p>It's not even the full box, just the blue field</p>
  
  <p>Any insights on disabling it? The only success I've had is turning calculation to manual, but the workbook needs automatic calculation</p>
  
  <p>Thanks!</p>