VBA Help with xlveryhidden

[decadence]

Hi, I have been tasked with cleaning up an old add in, however the Issue is that I have set the xlveryhidden sheets to xlvisible in the VBE but they are still not visible, I have also tried to unhide the sheet afterwards but all I can see is the standard sheet 1-3 tabs. Have I missed something?

 

[Jerry Sullivan]

Hi decadence,

Worksheets in files that have been installed as Add-In's are never visible. If you want to convert your file from an Add-In to a standard macro-enabled workbook, you can change the IsAddIn property in the ThisWorkbook module to False. Then Save your file using an .xlsm extension.

 

[decadence]

Hi Jerry

Thank you, I knew it was something so simple. Much Appreciated