PDA

View Full Version : Solved: Delete Sheets in Add-in



realitybend
08-08-2008, 10:48 AM
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
08-08-2008, 10:50 AM
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.