Remove an obsolete worksheet from an addin.

E

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)
 
R

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
 
R

RB Smissaert

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

ThisWorkbook.Sheets(1).Delete


RBS
 
Top