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?
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

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
 

Forum statistics

Threads
1,141,139
Messages
5,704,515
Members
421,353
Latest member
jekoxien15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top