What would cause the codename to change?

[tom88Excel]

Hi guys,


My spreadsheet codenames get changed sometimes and this caused my code to run incorrectly... I don't know what caused this error??? Can you please help me???




For example I have a worksheet codename is APPLE, and I have some private sub code in that spreadsheet APPLE.. sometimes this worksheet get changed from APPLE to APPLE1. On the VBAproject Window, I see that the properties on APPLE became a workbook with a workbook icon and all private sub code in APPLE stays in APPLE and the worksheet became APPLE1.. This cause my other code to not work correctly...


Can someone please tell me what has gone work?

Thank you all