deleted worksheet but in VBA code, the sheet still exists in the Microsoft Excel Objects

[mauler69]

I have a workbook (the uses macros) with multiple sheets. We have to constantly copy a template sheet to create sheet to get the macros to copy for each sheet, but when I delete one of the sheets, and open the VBA editor, in the Microsoft Excel Objects, there is still an entry for the deleted sheets that contains all the macro code. I right click on that object, but the Remove Sheet option is disabled. I deleted all the macro code from the object, and still won't allow me to delete the object. How can I remove these "ghost" objects from the workbook?

Thanks

 

[steve the fish]

Did you try closing and reopening the workbook?