Remove an obsolete worksheet from an addin.

[Ed R]

Right clicking an item in Project Explorer displays a menu with a removal
option.
In addin this option is active for modules and forms but greyed out for
sheets.
Is there a way to activate the removal option for sheets?
What is the best way to get rid of the obsolete sheet?
(Original .xls file is not available)

 

[Ron de Bruin]

Hi Ed

Change the add-in proprty to False

1) Alt F11 to open the VBA editor
2) Select the ThisWorkbook module of the add-in
3) Press F4 to open the properties window
4) Change the IsAddin property to false
Now you can delete the worksheet because it is a normal workbook now
5) When you are ready change the IsAddin property to true
6) Click the Save button in the VBA editor to Save the add-in
7) Alt q to close the VBA editor

 

[RB Smissaert]

Another way is to run code to delete the offending sheet:

ThisWorkbook.Sheets(1).Delete


RBS