title: Protect Sheet but unprotect text input shape
body: <p>I have been Googling and searching this site. I am sorry if this is a simple question or has been answered often, but I have yet to find my solution.</p>
  
  <p>In essence, I have created a sheet that is filled with input form control objects (not ActiveX) stuff and a few shapes. </p>
  
  <p>So I have this sheet I want to protect, but I want to select specific shapes (a couple text boxes) that allow input. I don't want the user moving stuff, clicking random cells, etc. I want 5-6 specific form controls I have named to allow input, and everything else is locked down.</p>
  
  <p>How do I do this? Again, sorry for what should be a simple answer, but apparently my searching isn't asking the correct question.</p>
  
  <pre><code>' Locks the main config pages and hides everything the user shouldn't touch
  Public Sub ProtectUserFromUser()
  
      Set configsheet = Sheets(MgmtConfigSheet)
      Set authsheet = Sheets(AuthDataSheet)
      Set mydebugsheet = Sheets(debugsheet)
  
      authsheet.Visible = xlSheetVeryHidden
      configsheet.Visible = xlSheetVisible
      mydebugsheet.Visible = xlSheetVeryHidden
  
      Call UnprotectInput
      configsheet.Protect
  
  End Sub
  
  ' All the fields user should be able to input on here
  Private Sub UnprotectInput()
      Set x = configsheet.Shapes("testInputBox")
      x.Locked = False
  
  End Sub
  </code></pre>
  
  <p>What's happening here is I can still click around and select cells, but I cannot type any input characters in the <code>testInputBox</code>. The variables when I set the <code>Sheets</code> are good. How can I make the <code>configsheet</code> only respond or accept input in select locations/shapes/ranges, etc?</p>
  
  <p><strong>UPDATE</strong> To make it clear, the text box I am trying to type in while not allowing user movement of the text box, was created as a <code>Shape</code> and it's embedded within a worksheet, not in a form. The <code>Locked</code> and <code>Lock text</code> boxes are unchecked in the <code>Shape</code> property.</p>