Add Sub to Button Bar
 

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.

Add Sub to Button Bar
 

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.

Add Sub to Button Bar
 

Is personal.xls already created? Or is this something I need to create?

"Duke Carey" wrote:

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.

Add Sub to Button Bar
 

Are all your Sub's in the same workbook?

If yes, then maybe you could use this:
http://contextures.com/xlToolbar02.html
from Debra Dalgleish's site.

Stanley wrote:

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.

--

Dave Peterson

Add Sub to Button Bar
 

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.

"Dave Peterson" wrote:

Are all your Sub's in the same workbook?

If yes, then maybe you could use this:
http://contextures.com/xlToolbar02.html
from Debra Dalgleish's site.

Stanley wrote:

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.

--

Dave Peterson

Add Sub to Button Bar
 

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.

Stanley wrote:

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.

"Dave Peterson" wrote:

Are all your Sub's in the same workbook?

If yes, then maybe you could use this:
http://contextures.com/xlToolbar02.html
from Debra Dalgleish's site.

Stanley wrote:

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.

--

Dave Peterson


--

Dave Peterson