title: Run-time error '1004' when script is ran from PERSONAL.XLSB
body: <p>I have a VBA script that works fine when it's in a module within a workbook, but if I put it in a module in my <code>PERSONAL.XLSB</code> file, I get this error:</p>
  
  <p>Run-time error '1004':</p>
  
  <blockquote>
    <p>Cannot rename a sheet to the same name as another sheet, a referenced
    object library or a workbook referenced by Visual Basic</p>
  </blockquote>
  
  <p>This is apparently the offending portion of the script that is creating the error:</p>
  
  <pre><code>.Sheets.Add(After:=.Sheets(.Sheets.Count)).Name = "ValidateData"
  </code></pre>
  
  <p>This script is to be used in many workbooks, so in order for that to work, I feel like it has to be in the <code>PERSONAL.XLSB</code> file. I don't understand why the error only comes up when it's coming from that file and not its own file.</p>
  
  <p>And just to be clear, there isn't already a worksheet called ValidateData at this point in this script.</p>