title: hiding formulas in formula bar
body: <p>When I used, in visual basic, the codes shown below, the <code>HYPERLINK</code> part appears in the formula <code>bar</code>, in the worksheet. I just want the <code>"TextHere"</code> to display in the formula bar.</p>
  
  <p>What additional codes can I add? I've tried to hide it by changing its properties in the protection tab, but it does not allow me to edit the TEXT anymore. I would like it to still be edit-friendly.</p>
  
  <pre><code>Sub IndexingSheets()
      Sheets(1).Range("A1").Formula = _
      "=HYPERLINK(""#" &amp; ThisWorkbook.Sheets(2).Name &amp; "!A2"", ""TextHere"")"
  End Sub
  </code></pre>