Excel Activate sheets by codename from the Personal.xlsb
How do I activate/access sheets by codename from the Personal.xlsb I want it to work for 2 scenarios: 1) Recently downloaded Excel report in the temporary folder, with one sheet, Worksheet name and codename are both sheet1. 2) Workbook has been saved and the worksheet name has been changed from Sheet1 but the codename is still Sheet1 and I want to refer to the codename.
This question generated 9 answers. To proceed to the answers, click here.