title: Excel VBA - Allow input to cells with DisplayFormulaBar=False
body: <p>OK it's taken me a while to figure this out and it is extremely annoying...</p>
  
  <p><strong>Excel 2013 Pro Plus</strong> <em>Fully patched to July 2014</em></p>
  
  <p>In my project I have </p>
  
  <pre><code>    Application.DisplayFormulaBar = False
  </code></pre>
  
  <p>which works as expected, it hides the FormulaBar.  What is NOT expected is that it Stops the inputting of data into any cell.</p>
  
  <p>I have to do a </p>
  
  <pre><code>    Application.DisplayFormulaBar = True
  </code></pre>
  
  <p>to allow the inputting of data again which is inconsistent with the design of the application.</p>
  
  <p>Does anyone know of anyway to hide the FormulaBar and still allow input into cells?</p>
  
  <p>I'm using my own validation inside the VBA code to ensure right place and value...other cells are locked.</p>
  
  <p>Many thanks in advance,
  regards
  Seán</p>