excel 2003 - macros & buttons

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikey - 19 May 2005 11:22 GMT

I have created two macros in a spreadsheet - SortByName amd SortByVersion -
how can I put two buttons in the spreadsheet to run the macros ?

I've looked in help and it keeps telling me about putting buttons in
toolbars, which is not what I want to do

regards
Mike

Reply to this Message

Bob Phillips - 19 May 2005 11:35 GMT

Go to Tools>Customize. In the dialog you will see an item under Toolbars
called Forms. Check that and you will get a new toolbar with a commandbutton
on it, just drag that onto the spreadsheet and assign the macro when asked.

Signature

HTH

Bob Phillips

> I have created two macros in a spreadsheet - SortByName amd SortByVersion -
> how can I put two buttons in the spreadsheet to run the macros ?
[quoted text clipped - 4 lines]
> regards
> Mike

Reply to this Message

mikey - 19 May 2005 11:51 GMT

Cheers Bob ! that did the job

> Go to Tools>Customize. In the dialog you will see an item under Toolbars
> called Forms. Check that and you will get a new toolbar with a commandbutton
[quoted text clipped - 9 lines]
> > regards
> > Mike

Reply to this Message