title: Excel VBA to go into cell in each sheet and refresh (F2+Enter)
body: <p>I already have a macro that goes into cell F4 of each Sheet and renames that sheet that name (I am running a lot of indirects because I am pulling from a lot of different sheets). Every F4 cell on every sheet is linked to a Master sheet that has all the names - so when I change the Hardcode in the Master it changes cell F4 for that specific sheet. However, in order for the macro to run and that sheet to rename itself to whatever F4 is, I need to manually go to that sheet and click F2 and then Enter in cell F4 and then the Macro renames the sheet and everything else works. How can I have it so that it would do that automatically?</p>
  
  <p>-Terribly sorry if this has been solved, read through a bunch of comments but none really addressed what I need</p>
  
  <p>'''This is what I have for renaming sheets, just need to adjust it so that it "F2 and Enter"s itself after I change the master file, which in turn changes the value of cell F4"</p>
  
  <pre><code>Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Target.Address(0, 0) = "F4" Then
      Sh.Name = Sh.Range("F4").Value
    End If
  End Sub
  </code></pre>