title: In excel how do I change the spreadsheet name from lower case to upper case
body: <p>Using VBA in Excel <strong>is there a way to change the tab name for the worksheet from lower case to upper case?</strong></p>
  
  <p>I have a workbook with over 50 sheets and changing the names individually does not appear to be a very appealing option.</p>
  
  <p>The <strong>name of the spreadsheet is in cell A1 and in uppercase already</strong>. Just need the actual sheet name to be uppercase.</p>