excel 2003 - macros & buttons

  • Thread starter Thread starter mikey
  • Start date Start date
M

mikey

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 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.
 
Cheers Bob ! that did the job

Bob Phillips said:
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.
Click to expand...
 
Back
Top