title: Using VBA Macro To open Link to picture
body: <p>My goal of this program is to open a picture in a folder by selecting a cells value in the active row which im using the line to do. </p>
  
  <pre><code>picture = Cells(ActiveRow, 6).Value
  </code></pre>
  
  <p>I am getting a Run time error '1004' Application-defined or object defined error</p>
  
  <p>Here is my full code</p>
  
  <pre><code>Sub Picture_Click()
  
     Sheets("Master").Unprotect Password:="Conti1"
     Sheets("Records").Unprotect Password:="Conti1"
  
     Dim picture As String
     Dim ActiveRow As Long
  
  
     Worksheets("Master").Activate
  
          ActiveRow = Rows(ActiveCell.Row).Select
          picture = Cells(ActiveRow, 6).Value
  
  ChDir"P:\926_TM\03_LocalExchange\Tracking_and_Labeling\LabEquipment\pictures"
  
      Workbooks.Open picture
  
  End Sub
  </code></pre>
  
  <p>I am trying to use the value from the selected cell to be the name of the picture file in the selected folder, the picture I would like to open.</p>
  
  <p>also I am getting a value of -1 for ActiveRow</p>
  
  <p>Any help would be great!</p>