Distributing macros with an addi-in

[OughtFour]

Please lend a hand to someone who has written a fair number of macros for
Word and is now trying to understand the world of Excel.

The macro in question is simple and runs fine.

I've put it in an ad-in with a custom toolbar with the macro on it, and
written a Workbook_AddinInstall() routine in the ThisWorkBook object that
adds a menu item for the macro; also a Workbook_AddinUninstall() that
deletes it.

These macros also behave as expected when run manually from within the vba
editor.

But here is what happens when I install the add-in on another computer and
then add it using the tools > add-ins.

1) The macro is not available using tools > macros.

2) The Workbook_AddinInstall() macro does not run and the menu item is not
added

3) The toolbar is available, but the button no longer runs the macro.

If I open the add-in from within Excel, I can then reassign the macro to the
button on the toolbar and then it will run--for as long as the add-in is
open (not just added in, but actually open using File > Open).

I'm going to skip the code because the code seems to run fine. The problem
is in how I am going about things. Can someone please tell me what the right
way is? (If there is a decent explanation on the web, a link would suffice
and be much appreciated.)

Thank you very much.

 

[gimme_this_gimme_that]

This old post of mine about how to install an Excel AddIn might be
helpful:

Tells you where to install it and how to get Excel to see it.

http://groups.google.com/group/micr...hat%40yahoo.com+&rnum=4&#doc_43faca8e01390c4d

 

[OughtFour]

----- Original Message -----
From: <[email protected]>
Newsgroups: microsoft.public.excel.programming
Sent: Friday, March 09, 2007 7:41 PM
Subject: Re: Distributing macros with an addi-in

This old post of mine about how to install an Excel AddIn might be
helpful:

Tells you where to install it and how to get Excel to see it.

Thank you for your reply. I've done the basic stuff you write
about--installed the add-in and linked to it and all that. My problems are
elsewhere, I think (Why won't macros load?). But thanks anyway.

 

[paul.robinson]

Hi
Is the Workbook_AddinInstall() called by the Workbook_Open sub? Also,
what is the macro security level set at on the other PC (you need to
click on "Trust Access to Visual Basic Project" in the trusted
Publishers tab in macro security)
regards
Paul

 

[gimme_this_gimme_that]

I had a Workbook_AddinInstall method so I could go back and forth
between developing in an Excel Workbook and then later saving my work
as an AddIn.

Workbook_AddinInstall wasn't needed to actually install the AddIn.

I forget what others had to set their security at.