title: Double clicking on a cell in Excel, open source file of that line on userform
body: <p>I am trying something and I don't even know if it's possible.</p>
  
  <p>I have about 20 progress reports of projects. These projects are being updated by users that use a userform. 
  Once a week, I have a few macros running  that goes to each of them, copy the data and put them in a Project Summary that is in a different workbook. What I want is to be able to double click on the first cell in any given row( there's about 200 projects) in that Project Summary workbook and that opens that specific project in the already existing userform that the users are using. But I want it to open it at the source file not in the data dump of the Project Summary worksheet. </p>
  
  <p>Is there a way I can do this? </p>
  
  <p>EDIT: </p>
  
  <p>I have tried this: </p>
  
  <pre><code>Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
  Dim Cell As Range
  
  If Intersect(Target, Range("A:A")) Is Nothing Then
  Else
  For Each Cell In Range("E:E")
      If (Cell.Value = "A, B") Then
          Workbooks.Open Filename:= _
              "filepath", Password:="...", ReadOnly:=True
          progressReport.Show
  
      End If
   Next Cell
   End If
  
   End Sub
  </code></pre>
  
  <p>I willdo that for each of the 20 other progress report based on the value of Range(E:E). What I want is that when it open the file to load the userform, it load the specific report for the value in A</p>