excel 2003 - macros & buttons
 

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

Go to ToolsCustomize. 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.

--
HTH

Bob Phillips

"mikey" wrote in message
...
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

Cheers Bob ! that did the job

"Bob Phillips" wrote in message
...
Go to ToolsCustomize. 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.

--
HTH

Bob Phillips

"mikey" wrote in message
...
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