Button to activate a macro

G

Gary''s Student

View > Toolbars > Forms

Click the "button" button and draw the button on the worksheet
Tell the Wizard which macro to assign
 
J

Joe

You can create a button from the Userforms list, and associate the
macro to this button. Go to Tools>Customize>Forms. Select "Forms" and
this will add all Userforms to the toolbar.

Now you can click on the button symbol and create the button on the
spreadhseet. Then right click on the button to find a bunch of
options, including how to assign a macro to this button.

Hope this helps.

Joe.
 
J

JE McGimpsey

If it's a Forms toolbar button, right-click the button and choose Attach
Macro.
 

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

Similar Threads

VBA word change keys 0
Macro to copy table of contents to a new doc 0
Problem activating pre-installed MS Office home and Student 0
Hyperlink fails to open on the first click 0
Need Help with Macro Security 1
Easiest Way To Insert an Activity (Task) 0
Macro warning in word 1
VBA for Dependents shortcut menu 0

Top