title: Open read only workbook for editing
body: <p>I am trying to automatically update a file on the server that is accessible to everyone as read only. Editing is only for a few people. Therefore, it is password protected, but only for editing and not for opening.</p>
  
  <p>I tried to write a macro to open a password protected file, but that only works for files that are protected against opening. I tried the following code as others suggested it might help to turn of displayalerts and/or ignorereadonly, but that does not help. I keep getting a pop-up that says "Enter password for write access, or open read only". I even tried SendKeys to enter the password, but than the pop-up shows too.</p>
  
  <p>Any suggestions that I might not have though of?</p>
  
  <pre><code>Application.DisplayAlerts = False
  Workbooks.Open Filename:="test.xlsx", IgnoreReadOnlyRecommended:=True, Password:="password", ReadOnly:=False
  
  Application.DisplayAlerts = True
  </code></pre>