title: Hiding Rows in Inactive Sheets in Excel 2013
body: <p>Switching to Excel 2013 from Excel 2010,</p>
  
  <p>When Sheet2 is inactive</p>
  
  <p>The code</p>
  
  <pre><code>Worksheets("Sheet2").Rows("432:432").EntireRow.Hidden = False
  </code></pre>
  
  <p>gives Error</p>
  
  <pre><code>Unable to set the Hidden property of the Range class
  </code></pre>
  
  <p>But works fine when Sheet2 is the Active Sheet</p>
  
  <p>In Excel 2010 , VBA had no problem hiding rows in InactiveSheets .</p>
  
  <p>Is this a change in Excel 2013. If so, any fix.</p>
  
  <p>EDIT:
  <code>Worksheets("Sheet2").Protect Password:="password", userinterfaceonly:=True</code> <code>Worksheets("Sheet2").Rows("2:2").EntireRow.Hidden = False</code> 
  When setting userinterfaceonly option to true, VBA Code to hide row only works when the sheet is active</p>
  
  <p>I can't recreate this error on a new 2013 Worksheet. But only when opening 2010 Excel app in 2013. Wonder If I am playing with any Settings here.</p>