I've inherited a workbook from a previous employee that is used for simply directing behavior of a phone rep. It contains a user form with checkboxes and option buttons, that, when selected, bring up the same form but with different selections. It's used as a guide for directing behavior (questions) on a call.
The issue I'm seeing is that in the VBA project explorer, there are 17 sheets (sheet1, sheet 2 etc.) that don't actually exist in the file anymore, with the excel green X icon as opposed to the normal sheet object icon. There is also the normal ThisWorkbook object (with the usual excel green X icon) and then there is a ThisWorkbook1 object as well.
The excess, unused sheet objects and the extra ThisWorkbook icon aren't deletable via the usual means. Also, none of them have code and don't appear to serve any purpose.
Short of copying everything to a new, clean workbook, is there an easier fix? I won't be able to run a code cleaner or similar product due to internal company security policies.
What are the usual causes of something like this, it's the first time I've come across dual ThisWorkbook objects?
Thanks,
Steve
The issue I'm seeing is that in the VBA project explorer, there are 17 sheets (sheet1, sheet 2 etc.) that don't actually exist in the file anymore, with the excel green X icon as opposed to the normal sheet object icon. There is also the normal ThisWorkbook object (with the usual excel green X icon) and then there is a ThisWorkbook1 object as well.
The excess, unused sheet objects and the extra ThisWorkbook icon aren't deletable via the usual means. Also, none of them have code and don't appear to serve any purpose.
Short of copying everything to a new, clean workbook, is there an easier fix? I won't be able to run a code cleaner or similar product due to internal company security policies.
What are the usual causes of something like this, it's the first time I've come across dual ThisWorkbook objects?
Thanks,
Steve
