New Menu add-in

Hi,

My questions is two fold. Firstly I use a colleagues (no longer in the business) Excel menu which when you open his excel document saved in his folder adds this new menu to my excel menus without opening his document.

I have created a new menu using some saved macros but when I run my macros from the menu the excel sheet containing my macros always opens up.

How can I - A) Make my New Menu add to colleagues Excel without them needing to open my document, and B) stop the sheet containing my macros open each time a macro is run from the menu???

Thanks in advance

Originally Posted by royUK

You need to add the menu with code. See the examples here

Darn, that site is blocked at work, will have to check when I get home, thanks