title: Applying macro from worksheet to workbook
body: <pre><code>Sub ScreenTip()
      Dim hl As Hyperlink
  
      For Each hl In ActiveSheet.Hyperlinks
          hl.ScreenTip = CStr(hl.Range.Value)
      Next
  End Sub
  </code></pre>
  
  <p>I have this code but it only runs on the Worksheet that you are currently on. I would like it to run over the whole workbook. How would I change this to do that?</p>