Add Sub to Button Bar

S

Stanley

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.
 
D

Duke Carey

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
 
S

Stanley

Yes I created a workbook called myaddins.xls and was hoping to be able to
pull them from that workbook into excel with custom images hopefully.
 
D

Dave Peterson

If you put your images in a worksheet (hidden???), you can copy and paste.

Try googling with the *excel* newsgroups for .pasteface
and you'll see lots of samples.
 
Top