title: Macro to insert hyperlink based on specific text entered in cell
body: <p>Working on an inspection checklist,
  Users instructed to enter "Ok" or "X" in cell.
  Sheet columns are the months and the rows are the components being inspected. If user enters an "X", I want that cell to automatically change to a hyperlink with the cell still displaying an "X"   The hyperlink should take the user to Sheet2 in the workbook where they will enter exception information. Needs to be for multiple columns.
  Here is what I have, but it does not work.  Thanks for any help you might have.</p>
  
  <pre><code>Sub Exceptions()
  '
  ' Exceptions Macro
  
  ' Macro recorded 12/9/2010 by
  '
  
  '
  If ThisWorkbook.Sheets("Inspection").Range("B9").Range("B100").Value = "X" Then
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
      "Exceptions!A1", TextToDisplay:="X"
  
  
  End If
  
  End Sub
  </code></pre>