making Add-in macros available

[robnot]

I've created an Add-in (.xlam file) in Excel 2007 and installed and activated it (it shows up under "Active Application Add-ins" on the Add-in menu for new workbooks). I can see the macros and code when I go to the VBA editor, but the macros don't show up in the regular macro list.

I know that I can write code for the new workbook that will reference the Add-in code, but I want other users to be able to install the add-in and run the macros in it right away without any knowledge of VBA. Is there a way to make this possible?

[royUK]

I have you installed the addin properly?

[robnot]

So far as I know it's installed properly. There aren't really any options for installing them other than being active or disabled, are there? The Add-in (it's just an excel Add-in... a workbook with code that's invisible to the user) is installed and active, the code is viewable when I enter the VB editor. By default, I believe that Add-in macros aren't available to a workbook through the usual macro list - I guess the Add-in truly is an invisible workbook.

What I want to know is if there's anything I can do or change that would make the macros available to other users without them having to open up the VB Editor (except maybe to change settings) after they install the Add-in.

Is there a way to have the macros show up in the list, or in buttons in the ribbon (or anywhere in the old 2003 interface if I convert my code), or attach them to key-combination?

[royUK]

You need a menu, but Excel 2007 does not have Commandbars, you can program the Ribbon but it is not simple.

what you could do is save your addin to an earlier version & create a menu, then when you install it for 2007 you will be able to see the commands in the Add-in Tab

[robnot]

How would I go about creating a menu? And what exactly do you mean by "an earlier version"?

[royUK]

I think you will need to create your menu in a version prior to Excel 2007 because 2007 does not use commandbars and toolbars. have you got access to perhaps Excel 2003?

[robnot]

Yes, I've got a separate machine with office 2003 on it.

[royUK]

I have just experimented and you don't need to create in an earlier version. Place this code in a new Standard Module, edit it to suit your needs.

Please Login or Register  to view this content.

Then in the Workbook Object add

Please Login or Register  to view this content.

You should now be able to access the addin from the Add-ins tab of the Ribbon, look for MyMenu

try this example

[robnot]

How would I go about creating a menu in Excel 2003?

[robnot]

I'm a little confused... should the above code be added to the Addin or to a new workbook?

[royUK]

You need to add it to the addin,have a look at the structure of the code,

Please Login or Register  to view this content.

I have uploaded an example so that you can experiment.

[robnot]

OK, I figured it out. Thanks so much for your help, I was really stuck on this one!