Extra objects in the VBA project explorer.

[raven_squire]

Hello,

I recently had stability problems with some code and it crashed Excel mamy times. Now when working in the VB edditor the VBA project tree has duplicated the sheet and workbook objects (although the new objects have no code). I have sheet1, sheet11,sheet111, sheet1111(logooutput) etc

What has happend and how do I get rid of duplicated objects?

Will there be any other problems caused by my bad code?

 

[Nutster]

What happened will depend exactly on why the application crashed. How to fix it is more straight-forward. Each worksheet should appear in the sheet tabs on the main Excel window, which is usually at the bottom-left. Find each sheet you do not want, right-click and click on Delete. Confirm the delete and that should take care of it. Just keep going until you have deleted all offending worksheets. If you have an item in the project tree that you do not want to keep which does not appear on the worksheet tabs, then in the VBA project items, right click and choose Delete on each item; confirm you want it gone and it is. It might be a good idea to save the Excel file after each successful deletion, just to be safe

 

[raven_squire]

I was undable to determin what caused the crash and "Automation Errors". I was able to identify the code that caused it and remove it. That code worked just fine in another sheet.

I can not "Remove" any of the objects in the explorer as the option is greyed out.

Is there some way to have the back end of the spread sheet cleaned?