Addin TO create menu

[jjyxk845]

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?

 

[Wolfshead]

Hi
You could create a procedure called Autpen 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