Add Sub to Button Bar

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

[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


"Stanley" <Stanley@discussions.microsoft.com> wrote in message
news:33E0BCAA-4867-4C75-A275-D5D6F02E01BE@microsoft.com...
> 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.

[Stanley]

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" <Stanley@discussions.microsoft.com> wrote in message
> news:33E0BCAA-4867-4C75-A275-D5D6F02E01BE@microsoft.com...
> > 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]

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

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

"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]

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