Solved: Delete Sheets in Add-in

[realitybend]

I saved a workbook with a bunch of sheets as an add-in. Now the add-in file size is huge. How can I delete the sheets in the add-in?

Thanks.

[Bob Phillips]

In the VBIDE, select ThisWorkbook in the addin.

Change the IsAddin property to False. This will make the addin visible to Excel.

Go to Excel and delete the sheets.

Back in the VBIDE, reset IsAddin to True, and sve the addin in the VBIDE.