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

Press <Alt<F11 to go to VB. Find the macro you want to use, and remember
this name. It could be in a module of its own - Module 1 most likely, or in
This Workbook, or one of the worksheets. To move between these, double click
on the name in the left hand window, and you will see code if any in the
right hand window.
Also, you should use View Toolbars Control Toolbox to create a button. Once
you have the name of the macro, do as per my previous post.

Kassie
"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?