title: Excel won't let me select (or view) the source workbook with "Set varCellContent = Application.InputBox _"
body: <p>I have been using the following code to choose a source worksheet by clicking any cell in the source workbook.</p>
  <pre><code>' User choose source sheet
  Dim varCellContent As Worksheet
  Set varCellContent = Application.InputBox _
      (prompt:=&quot; &quot; &amp; vbNewLine &amp; &quot;Click any cell in source worksheet, then click OK&quot;, Type:=8).Parent
  Dim sht As Worksheet
  Set sht = Workbooks(varCellContent.Parent.Name).Worksheets(&quot;ap&quot;)
  </code></pre>
  <p>It has been working well for years but after making a few changes recently, Excel won't let me view or select the source workbook.  Funny thing is, the small changes I made were only <em>after</em> this section of the code, so it could well be unrelated to the code (Excel / Windows settings maybe??).</p>
  <p>The source workbook is already open (a CSV file), but when I click it in the taskbar, it won't switch to it.  It seems like it could be related to both workbooks being open in the same instance of Excel, because it also won't let me dock (snap) both each workbook left and right seperately.  If I dock one to the left, then I try and dock the other to the right, but they both go together.  I am sure I have not noticed this behaviour before.</p>
  <p>If I open another instance of Excel and then open the CSV file in that, I can dock seperately, and I can select the cell in the CSV file, but it is not reconised in the input box. (The cell reference does not show up when I click the cell).</p>
  <p>Have done plenty of googling but can't work what the heck has happened!???</p>