VBA Project - Sheets duplicate

**JPGraphX** · 03-18-2014, 07:59 AM

Hi!

I have a problem with macro sheet that duplicates, how can I delete the old one and get back to Feuil8 only, not Feuil8111111.

vba.jpg

Thanks,
JP

**Solus Rankin** · 03-18-2014, 10:34 AM

Instead of a picture, you can attach an example workbook.

To attach a workbook, click the 'Go Advanced' button below and use the paperclip in the toolbar to navigate to your document.

**JPGraphX** · 03-18-2014, 10:40 AM

Thanks! Here we go:

Template_Soumission_v11.xlsm

JP

**Solus Rankin** · 03-18-2014, 10:54 AM

Maybe

Please Login or Register  to view this content.

Untested. I'm not really strong with French.

**JPGraphX** · 03-18-2014, 11:03 AM

Good! Thanks! Is there an easy way to remove those unused sheet now?

**Solus Rankin** · 03-18-2014, 11:10 AM

Right click and delete?

**JPGraphX** · 03-18-2014, 11:15 AM

Lol no.. the "object sheets" in vba ..

**Andy Pope** · 03-18-2014, 11:58 AM

Not sure you can remove those imposter 'Thisworkbook' objects.

You may need to transfer all your good sheets and code in to a fresh workbook.

**TMS** · 03-18-2014, 12:00 PM

It's very off. They have references like sheet numbers but they actually refer to ThisWorkbook. Hence, you can't unhide them, you can't delete them, and they're not code modules so you can't remove them. Must have been an interesting bit of code.

Regards, TMS

**ragulduy** · 03-18-2014, 12:12 PM

If you save it as a .xlsx that should get rid of the "ghosts" of thisworkbook and then you can copy the code back in. Not sure if that is any quicker than copying everything into a new workbook as Andy Pope suggests.

Edit: A look around google suggests saving as xl95 workbook or using a workbook cleaner may also work