Sharing macros and buttons that accompany the macro

[Guest]

I have created macros that I wish to share with my co-workers. Also, I have
created custom buttons to accompany those macros. I have been researching
how to share these buttons and macros, but to no success. Is there any way I
can share custom buttons and macros?

I found an export module option in Visual Basic, but am a little hesitant to
try importing anything on another person’s computer without knowing it will
work.

Thanks for any help!

 

[Dave Peterson]

If you want to add an option to the worksheet menu bar, I really like the way
John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://groups.google.co.uk/[email protected]

 

[Guest]

We've just done this in our office.

There is a file called personal.xls where you can add macros that will be
available for any excel workbook instead of just one. If everyone in your
office opens excel from the same server location you may only have to add the
macro to one version of personal.xls. If you each have excel on your
individual desktops, it may have to be added for every user.

See http://office.microsoft.com/en-us/assistance/HA010872961033.aspx
for more info.

Once you have the macro available everyone can add a button that uses the
macro by customizing the toolbars on top(right click in toolbar area and
click customize, etc.).

If you have multiple servers this could be a bit more tricky as it was in
our case, but your Sys admin should be able to help.

hth,
Dave

 

[Guest]

This didn't make much sense to me. Perhaps my skill with VBA is to basic to
understand it. I did, however, figure out to copy and paste the personal.xls
file in my co-workers computer. I only need to figure out how to copy my
buttons created for them. I have approximatley 20 macros and do not want to
create 20 buttons on 21 laptops. Any ideas how to copy over the buttons?

 

[Guest]

Not off hand. But they dont need the buttons to run the macros. Once the
personal.xls has the macros, they can select tools, macro, macros and select
the macro they want to run and run it from there. to the extent a user would
like the benefit of a button they can add it. I did it by adding one menu
and then adding buttons under each.


I've pasted my instructions for my colleagues below for adding a menu with
buttons. Perhaps by sending the instructions, only those that would like to
use them can do it themselves. These are for Excel 2002, but they can
probably be easily adaptde to other versions.


To add menu/buttons…

1. right click in grey area to the right (outside) of any of your toolbars
at the top of Excel and select “customizeâ€
2. click on Commands tab, and select new menu; click and drag New Menu from
right pane of commands window up to the right of your rightmost menu(probably
the Help menu)
3. leave the customize window open for steps 3-6, right click on new menu
and select name, and rename “Macrosâ€
4. right click on new menu and select “begin a groupâ€; select Macros in the
Commands tab of the Customize window and click and drag Custom menu item from
right pane of Commands window to newly created Macros menu, and then(without
letting go of mouse button) drag to small grey (empty) box under menu.
5. right click on custom menu item and click “Name†and rename appropriately
for each macro
6. right click on renamed custom menu item and select “assign macro†and
click on corresponding macro.
7. close customize window

Dave

 

[Guest]

Thank you!!!! very much!

You saved me a lot of time.