Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Assign Macro Dialogue box not appearing

    Every time i drag a new button onto a worksheet and right click i should get a assign macro dialogue box from which i should be able to assign a macro directly. I never get this option whatever i try. Am i doing something stupid? Using 2002. Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Phoenix, AZ
    Posts
    12
    When you right click on the button, do you get a popup that has:

    Cut
    Copy
    Paste
    Properties
    View Code
    CommandButton Object
    Grouping
    Order
    Format Control

    ????

    There are two toolbars that can be used to put buttons, combo boxes, etc on a worksheet. one is the Control Toolbox toolbar (which gives you the commands above) and the other is the "Forms" toolbar, which would give you the "Assign Macro" option when right clicked. Make sure that you have the Forms toolbar added and that you are using the correct toolbar button.

    PS, you can use either to run a macro. On the Control Toolbar, you can click on "View Code" and manually key the Macro() you want to run.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •