title: Excel thinking cells are locked when they aren't
body: <p>I have quite a complicated workbook which i have very heavily locked down so it cant lose its structural integrity when being used by the user. It works like a dream in Excel 2003, 2007 and 2010 however when i use it in 2013 if i try and type in to an unprotected cell excel thinks that its protected, i can then unprotected the sheet manually and it still wont let me type in to the cell im then mysteriously allowed to unprotected the worksheet AGAIN and then it allows me to enter in to the cell and also get in to the cell formatting to demonstrate that the cell is definitely not locked. Its then made even more complicated when i then navigate to another protected sheet and i then find it unprotected.....</p>
  
  <p>I have messed about with the sheet more and more and the problem appears to be when my macro moves me from one sheet to the next it believes its still on the previous sheet. </p>
  
  <p>For example on the front sheet i have cell K16 as named cell called "ChangePW"</p>
  
  <p>I then run my macro to select another sheet (shown below)</p>
  
  <pre><code>Application.ScreenUpdating = False
  Sheets("Income&amp;Expenditure").Select
  Worksheets("Income&amp;Expenditure").Unprotect Password:="*****"
  Range("B3").Value = "OSC" 
  Worksheets("Income&amp;Expenditure").Protect Password:="*****"
  Range("B2").Select
  Application.ScreenUpdating = True
  </code></pre>
  
  <p>I then proceed to enter some data in to the the Income&amp;Expenditure tab but i get a warning that the sheet is protected even though i have selected an unprotected cell. I then click on cell K16 on the Income&amp;Expenditure sheet and it still thinks its called "ChangePW". As a result of this its applying the protection layout of the front sheet on the Income&amp;Expenditure sheet. Even when i click on the Income&amp;Expenditure tab at the bottom and click "Show Code" its showing me the code for the Front Sheet!!</p>
  
  <p>All of the vba works perfectly in 2007 and 2010 so im absolutely stumped at the moment. </p>
  
  <p>I have been navigating forums for the last 2 weeks trying to find an explanation with no successes, has anyone else experienced anything like this or know of a cause? i reiterate that it works perfectly in all other versions of Excel....</p>
  
  <p>Thanks</p>