Thread: add-in?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default add-in?

Hi
I thought you already have some code for adding menu items, etc.

--
Regards
Frank Kabel
Frankfurt, Germany


Steph wrote:
Hi Frank. Thanks for the response....but what code?

"Frank Kabel" wrote in message
...
Hi
put this code in the workbook_open event of your addin file. This

way
the code gets started then installing the addin

--
Regards
Frank Kabel
Frankfurt, Germany


Steph wrote:
Hi. I was trying to create a file that I could send out to a
department that would be a sort of add-in (probably a bad choice of
words). Basically, I want the receiver to double click on the

file,
and have it automatically create a new menu button, and under that

a
custom menu item, and finally assign a macro to the new menu item.
I can do it manually, but can it be done in code in such a way the
file auto-installs the menu item? Thanks!