Button on tool bar for macro

[CooterBrown]

I wrote a button then to attach a button to it, I did the following:

right click on tool bar
click customize
click commands tab
under catagories I clicked macros
then under commands I dragged Custom Button to the tool bar
right clicked on the custom button then assigned the macro

When I save the Workbook and reopen it from the share drive, the button is there, however when my co-worker tries to open it, he doesn't have the button.

What is an easy way to allow users to call this macro from a menu or button?

Need more info?
THanks,
Coot

 

[AnotherHiggins]

A dead-easy way to create a custom menu:

http://www.j-walk.com/ss/excel/tips/tip53.htm

You can even download an example workbook, then tweak that to suit your own needs. A great instant solution and a great way to learn (if you play with it).

You'll need to put the file containing the macros on a shared drive. Then, on any computers on which you wish to use the macros, go to Tools > Options > General. In the At startup, open all files in box, type in the path to the network drive where the macro file resides.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.