assigning a macro to a button

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

Guest

I have a macro that runs fine and I added a button to my spreadsheet from
the forms control menu, but I can't figure out how to assign the macro to the
button.

I was expecting to see and "assign macro" option available when I right
click on the button, however it's not there.

Any ideas?

Thanks
 
Click the green triangle on the Controlbox Toolbar (design mode)
Right click your button.
From the context menu select View Code
Click to expand...
between the lines
Private sub
and End sub

type the name of your macro.

Turn off design mode and test it.

Hans
 
You added a commandbutton from the control toolbox. You can either follow
flummi's advice or delete that commandbutton and add a button from the Forms
toolbar.
 
You must log in or register to reply here.

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

How to identify macro assigned to toolbar button 3
Excel 2003 - assign macro to custom toolbar button 1
Assigning a macro to a command button 1
Assign a macro to the save button 4
Excel 2007 -- Assign a macro to a button 1
How to see which Marco is assgined to a form control button 2
macro does not assign to menu? 2
Assigning Macro to a Command Button 3

Back
Top