I need your help please. I am running a macro in a workbook. Interestingly, sometimes a new sheet like “This workbook” is inserted. This is then always extended with a 1. See screenshot. Unfortunately, macros for ActiveX elements are stored in the Overview Q-Messages worksheet. If another worksheet with a 1 at the end is added, the macros end up on this worksheet. Unfortunately, the buttons on the Overview Q-Messages worksheet then no longer show any reaction. How can I a) get rid of these unnecessary worksheets and b) how can I find out where, when and how they are called in my code so that I can solve this problem.

Thanks in advance.