PDA

View Full Version : cannot find MenuSheet in Excel Add-in



OPM
12-02-2013, 05:26 AM
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
12-02-2013, 06:05 AM
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
12-02-2013, 06:18 AM
Hi,

Thanks for your quick answer!

Where can I find these settings?

Aflatoon
12-02-2013, 06:27 AM
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
12-02-2013, 06:35 AM
Great, that's it!!

Thanks a lot for your help :-)

Aflatoon
12-02-2013, 06:37 AM
You're welcome. :)