creating buttons with a macro
Once a user starts macro1, it should create 5 buttons
during the macro and then assign a different macro to each
button.
For example, once macro1 is finished, there is a
spreadsheet with Buttons 1 - 5 across the top.
Button 1 has a macro to sort by date
Button 2 has a macro to sort by amount
Button 3 has a macro to sort by Customer Number.
I'm having trouble creating the buttons with a macro and
assigning the macro to each button. I also need help in
placing the buttons evenly across the spreadheet.
Any help you can provide to get me started would be
greatly appreciated. Thanks.
|