title: Editing Protected Worksheet From Another VBA
body: <p>I am working on a sign in book using Excel, coding with VBA. I have one tab with the form to type your information, another for the details to be stored upon login, and another to search for a logged user. I have protected Sheet1(Login), and need Sheet2(Log Book) to be protected as well.</p>
  
  <p><strong>The Issue</strong> The issue is that on Sheet2(Log Book) I want the VBA to be able to add the user's information in the next available row, while having it protected so nobody can go through and change others information. The following is the failed code which I have tried: </p>
  
  <pre><code>Private Sub Worksheet_Open()
      Worksheet.Protect "Password", UserInterfaceOnly:=True
  End Sub
  
  wksht unportect()/wksht protect()
  </code></pre>
  
  <p>Neither of these were working. How else might I achieve this?</p>