Assigning a macro to a button

  • Thread starter Thread starter outback
  • Start date Start date
O

outback

I under the impression that when I created a button on a worksheet,
that a dialog box would appear asking me to choose a macro to assign
to the button. This does not happen even though I have macros
available in the open workbook as well as in personal.xls. How do I
assign the macro to the button?
 
When you create the macro you are asked that question. Otherwise you
need to go to Tools, Customize, and then R-click the button and pick
Assign macro.
 
What kind of button, if you use one from the forms toolbar you will be
prompted as soon as you release the mouse after dragging it to the sheet? If
you use one from the control toolbox you need to right click the button and
select view code, then put you code there


--


Regards,


Peo Sjoblom
 
Peo said:
What kind of button, if you use one from the forms toolbar you will be
prompted as soon as you release the mouse after dragging it to the sheet? If
you use one from the control toolbox you need to right click the button and
select view code, then put you code there
Click to expand...
Oh, I was thinking he meant the buttons on the toolbars!
 
Oh, I was thinking he meant the buttons on the toolbars!
Click to expand...


Only the OP can tell, at least he has answers now that should cover
whichever it is


--


Regards,


Peo Sjoblom
 
I under the impression that when I created a button on a worksheet,
that a dialog box would appear asking me to choose a macro to assign
to the button. This does not happen even though I have macros
available in the open workbook as well as in personal.xls. How do I
assign the macro to the button?
Click to expand...

Thanks for the help. I was unaware that there were 2 ways to program
a button. I'll use the forms verson.
 
Back
Top