title: Hide row in excel by mouseover of particular cell
body: <p>I am using <code>=Hyperlink</code> in a series of cells in a worksheet to call a public function that changes the value of a particular cell. It works very well. But I want the function to hide a row when I mouse over a particular cell. Can anyone help?</p>
  
  <p>The code is:</p>
  
  <pre><code>Public Function highlightcell(seriesName As Range)
      Range("valSelOption") = seriesName.Value
  'enter code here to hide Row 1
  
  End Function
  </code></pre>