click on the button control and rubberband it onto your sheet
It should prompt you to assign a macro.
Select you macro
Now click the button.
Similarly, you can go into tools=>customize and create a button on a menu
and again, assign you macro to that.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.