VBA , cant delete Microsoft Objects in VBA

Question

Hello

We have created a workbook in VBA and using R it read and writes back to the workbook.

The problem is that when it writes using openxlsx package and saveworkbook it creates a lot of Microsoft Objects in VBA.

Is there a way to delete the Microsoft Objects ?

Thanks

Answer 1

Looks like you modified the VBA project and did something fundamental wrong?

IMHO the question is not how to delete this modules but to avoid the creation. Show me your code and at best the file too.

Andreas.

Answer 2

Hello and thanks for your reply. See below the image.

Sheet35 - Sheet47 are objects that have been created and we can't delete them. They don't correspond to any sheet. You can find the in the Developer tab / VBA on the left site.

In contrast to sheet 48 / sheet49 which correspond to actual sheets.

Is there a way to delete Sheet35 - Sheet 47 ?

Answer 3

Show me what you mean by "Microsoft Objects" and where you see them.

Andreas.