Addin TO create menu

jjyxk845

Board Regular
Joined
Sep 8, 2006
Messages
89
hi,

I've just finished creating my addin with all the my new functions etc.

How ever i have a small problem.

How to get the adding to create my menu when it loads.

I have a sub called makeMenu which i want to run as soon as the addin loads with excel.

Can any body help?
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Wolfshead

Board Regular
Joined
Oct 18, 2006
Messages
100
Hi
You could create a procedure called Auto_Open which calls the makemenu procedure, or you could double click the ThisWorkbook in the VBA Project Explorer and use the Workbook_Open event to call your menu loader.
Chris
 

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,335
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top