title: Set variable to a sheet's Codename, Using it in the code isn't working
body: <p>This works, referring to the codename directly (Sheet3)...</p>
  
  <pre><code>Sheet3.Shapes(PopUp).Visible = True
  </code></pre>
  
  <p>...but using a variable set to the same Codename value doesn't...</p>
  
  <pre><code>WS = ActiveSheet.CodeName
  WS.Shapes(PopUp).Visible = True
  </code></pre>
  
  <p>Why? I ask because I need to extend the larger macro's functionality to the whole workbook, so I'm hoping the variable will let this apply to whatever worksheet the user happens to be on.</p>
  
  <p>Thanks for any guidance!</p>