title: Excel VBA open same workbook twice, but one instance is read-only
body: <p>I created a read-only shortcut to a workbook that is writeable. Doing this, I can simultaneously open separate read-only and writeable instances of the same workbook when I manually click the shortcut and the actual document separately. However I can't seem to duplicate this in VBA code. Trying to open the same workbook from the read-only instance using VBA code closes the read-only instance and leaves me with only the writeable one, EG </p>
  
  <pre><code>Workbook.Open filename:=ActiveWorkbook.FullName, editable:=True
  </code></pre>
  
  <p>Running this from the read-only instance terminates the instance and replaces it with a writeable one. I'd like to be able to have both, but no idea how to do this? Reason is I want to be able to publish changes made in read-only instance to writeable one with user only needing write access to the writeable instance for a few seconds, enough time for the VBA code to open it, publish the changes, and quickly save and exit and re-activate read-only instance. This allows multiple people in a team to almost concurrently make changes to the same workbook without having to suffer the limitations of 'Share Workbook', while also simultaneously being able to view the document. </p>
  
  <p>But what if someone makes changes in between? Well, the user is told to reload the read-only instance if any changes have been made by someone else since the user opened the document, which just calls the above code where editable = false.</p>
  
  <p>Help greatly appreciated</p>