View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
stanshoe stanshoe is offline
external usenet poster
 
Posts: 34
Default I cannot use Assign macro in Excel. Could before but not now. A.

Dan-

Excel has two different toolbars, theForms toolbar and the Control Toolbox
toolbar, that contain Button controls which makes things confusing. If you
used the "Command Button" from the Control Toolbox toolbar you will not be
able to assign a marco. The "Command Button" from the Control Toolbox
toolbar uses the CommandButton_Click event to lauch macros.

Make sure you use the "Button" control from the Forms toolbar and you will
be able to right click to assign the macro.

-Stan Shoemaker
Palo Alto, CA


"OWU Programming" wrote:

Is there a VB command method to execute a macro if the
Assign Macro doesn't show. Or is there something
changed I need to fix.
TIA
Dan Cring