Share a toolbar that calls macro from an add-in

I have created some macros that need to be used in several workbooks by more than one users, so I put them in an add-in and gave them instructions on how to get the add-in. I also created a toolbar with buttons calling those macros, attached it to a workbook the users can open, and instructed them to open that workbook once to get the toolbar.

Both the add-in and the toolbar workbook are on a network drive that my users can access, but when they get the add-in, it gets copied to their own add-in folder.

Here's my problem:
When a user tries to click on one of the buttons in the toolbar, the button tries to call the macro using the path that would be valid on my computer to get to my add-in folder. This path includes my user name, so it doesn't go to their own add-in folder: it goes to my add-in folder on that computer if I ever logged in on that particular machine, or it goes nowhere.

When I created the button, I attached the macros by referring to the add-in workbook by name only, without referring to a path, so I don't know why MY path ended up defined on that toolbar.

How can I go around this? I manually relinked all the buttons for that user, and I can do it for the other users (there aren't that many users nor that many buttons), but I'd rather avoid it: I'll have to re-do it if the toolbar is updated and it just seems like more work than should be necessary.

I'm also opened to suggestions on a better way to share those macros. They can't be attached to the workbooks because we use new workbooks every year - they're emailed to us by the people who create them and for a variety of reasons, pasting everything into a workbook of our own is not a good option.

Thanks for any help,

Brigitte

It's much better to add your ToolBar within the code, there's many examples this is one I have edited from one of my existing workbooks.

Place this in a Standard Module, I have named the module mToolBars and it is added to the Data menu.

Please Login or Register  to view this content.

This code is important to make sure that the ToolBar is loaded correctly & unloaded when not needed.

Please Login or Register  to view this content.

Here's an example that adds it's own Toolbar

try changing the Username part of the file location by adapting this code

Please Login or Register  to view this content.

Something Like "C:\Documents and Settings\........" & strName

P.s. code thanks to ROYUK (Legend)

HTH

Hi Guys,

I have a bunch of macros that were created for charting/graphing. All of the macros work fine and I have them linked to a personal toolbar. I wanted to share the macros with some colleagues and understand that creating an add-in is the best way to do that. Someone pointed me to some code on the Contextures website (http://www.contextures.com/xlToolbar02.html). I don't know anything about coding and was only able to properly link two macros to the toolbars.

This may seem really naive, but can anyone help explain how I would add the names of my other macros to the toolbar and have them show up? I have already added all the macro subroutines to the module as suggested, but can't seem to figure out how to get the 10-12 other macros onto the Toolbar.

Thanks!

Please Login or Register  to view this content.

'===========================================

Please Login or Register  to view this content.

'===========================================

Please Login or Register  to view this content.

'===========================================

Please Login or Register  to view this content.

nishan22

You should start your own question & post a link to this one if relevant