title: Excel VBA 2007 Save workbook in read-only mode
body: <p>Lets say a workbook is writeable, but is opened for read-only (through a read-only shortcut where the <code>/r</code> switch is used), and it has not been modified since someone has had it opened for read-only. How to allow them to save changes from VBA for Excel 2007 without re-opening?</p>
  
  <p>I seemed to be able to do it with 2003 but not with 2007. In 2003 this seemed to work:</p>
  
  <pre><code>ActiveWorkbook.ChangeFileAccess (Excel.XlFileAccess.xlReadWrite)
  ActiveWorkbook.Save
  ActiveWorkbook.ChangeFileAccess (Excel.XlFileAccess.xlReadOnly)
  </code></pre>
  
  <p>But in 2007 no longer. Thanks</p>