View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
 
Posts: 268
Default Connecting button to macro

Right click on the button, click on View Code. You will see a procedure,
most likely called Button1_Click(), with a blank line below that, and in the
next line the words End Sub. In the blank line type in the name of the macro
you want to run. Return to your sheet, and click on the Design button to
exit Edit mode. If you click the button, it will run your macro.

"april27" wrote:

OK this does not sound very difficult but I have a problem finding the
correct macro and how to connect it to the button. I have made a button from
the ViewToolbarsForms in Excel. Now I already have code that I have placed
in a Modul. The only thing I want the button to do is to call a bigger
program that is found in the modul when pressed. When I try to connect the
button to desierd macro I do not succed to find the macro in the lis nor do
any manual attempts work. Can someone please help me?