MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Macro Distribution

  Asked By: Alex    Date: Mar 03    Category: MS Office    Views: 1886

I've written a series of macros and produced a (password protected) add-in
with a specific macro to add an item to the Excel menu bar to make it easy
for the users - all this works fine.

What I'm stuck on is distributing this to my users without giving them the

How do I distribute/install the add-in and get it to run the macro called
"AddMenu" during installation?



2 Answers Found

Answer #1    Answered By: Jacob Bouchard     Answered On: Mar 03

I have made a macro  based addin myself and have done what you require. Once
you have created your addin and pasword protected  it, you take the addin you
created to another computer,
In excel  go to tools -> addins -> Browse .... Open the directory where you
have placed your addin and say OK.
If your macro is properly built to setup the menu  created by you then
everything will be fine.

The password  protected addin will not be available for viewing by the users.

Answer #2    Answered By: Theresa Watson     Answered On: Mar 03

That helps a lot, but a copy of your code would be useful.

Didn't find what you were looking for? Find more on Macro Distribution Or get search suggestion and latest updates.