The fact you can subsequently close the workbook and quit Excel is irrelevant. When you start a new Excel session, as 'Set Xl = New Excel.Application' does, that new session can only update workbooks it opens; if the workbook was already open, the new session can only open it in read-only mode..
Last edited by macropod; 08-23-2018 at 04:53 PM.
Cheers
Paul Edstein
[Fmr MS MVP - Word]