creating a macro icon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a macro, how do I create the icon so someone can just click the
icon and it runs?

Thanks
 
Make the forms toolbar visible.

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.

Ask a Question

Back
Top