cannot find MenuSheet in Excel Add-in

[OPM]

Hi,
I have this Excel Add-in which contains several macro's we se to automatically proces a lot of data. Not created myself but by someone who has left the company. Now I want to add an extra button for some more data to proces.
But this macro uses a MenuSheet I cannot find in the Add-in, since there are no sheets in place. Somehow it get's its info for the added button to run the macro's, please see code below.
Can someone please help me out?

[Aflatoon]

A VBA add-in always has at least one sheet because it is basically just a workbook. You need to set its IsAddin property to false in order to view it.

[OPM]

Hi,

Thanks for your quick answer!

Where can I find these settings?

[Aflatoon]

In the VB Editor (Alt+f11), locate the add-in in the Project Explorer window, and expand it until you can select the ThisWorkbook object. Then in the Properties window (f4 if it is not already visible), change the IsAddin property to False. You should now be able to see the sheets in the main Excel window.

[OPM]

Great, that's it!!

Thanks a lot for your help :-)

[Aflatoon]

You're welcome.