Do you have your modules in personal.xls? If so, then it is easy to run
them from a toolbar.

Right click on the toolbar and choose Customize from the popup menu
In the dialog, navigate to the Commands tab
In the left panel select Tools
In the right panel scroll to the bottom and choose one of the Custom icons
Drag the icon up to the toolbar and drop it ON THE TOOLBAR - not on an empty
space
Right click on the dropped icon and choose Assign a macro
You can can right click again and change the icon to show Text Only and
change the text to something descriptive


"Stanley" wrote in message
...
Is it possible to add a button to the bar at the top and have it run a SUB
I
wrote? I have several SUBs that I have to run on many different
spreadsheets
and I get tired of having to attach the module and then run it. It would
be
so much easier if I could add a button like Adobe does.