duplicate sheets in vba project

[joecast]

hello all,
i am sure i have seen this before, but not able to fix this time. i have a workbook in which i have deleted some sheets which were no longer needed. now when i look at the excel objects i get this:

-- removed inline image ---

each sheet has a second "version" with a 1 postfix. also the Remove Sheet option is not available when i right click.
the last piece of the puzzle is in order to get the macros to work, i had to copy the code in each sheet object from for example, Sheet12 to Sheet121 and Sheet4 to Sheet41, etc.

does anyone know why this has happened? and also how do i remove the extra sheets? Thanks
Joe

 

[joecast]

bugger, posting pic didnt work. hope it makes sense without.
joe

 

[Sektor]

I had the same problem. I got this when I manually inserted VBA bin file into new workbook. I think the solution is to create new workbook and copy all code there.

 

[joecast]

thanks, hopefully thats not the only way around this. the workbook still operates fine, but all the formatting within the sheets means it would take ages to get a new workbook ready to use the code. copying the code across would be fairly straightforward though. cheers
joe