title: VBA- xlsm file has error 40036 with similar sheet names
body: <p>i have an issues with an macro that i'm writing. I have my xlsm file that i'm writing my macro in, it's creating a template that gets data from multiple spreadsheets that other people send me. However one file that i use for information is an xlsm file and is giving me problems. I believe i have isolated the problem but am unsure as to how to fix it.</p>
  
  <p>the first sheet is named "Piranha" (no idea why), and the second sheet is named "Piranha - Dist &amp; Growth split" </p>
  
  <p>however when i write stardard code like
  Sheets("Piranha").select</p>
  
  <p>it has a runtime error 40036 (Application- defined or object defined error)</p>
  
  <p>it also doesn't like 
  ActiveSheet.select / .name</p>
  
  <p>but only for those two sheets, there is another sheet named "Exceptions" and i can use that object no problem. Has anyone ever heard of this problem or better have any ideas on how to solve it? Also because it's not my file if there is a way to do it without actually altering the file would be amazing. Thank you!</p>