Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: Button to run macro

    How do I go about creating button on a sheet that will run a macro.

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    There are four ways to do this:

    1. Are you just wanting access to the code by clicking a button? If so, draw an object on the spreadsheet, right-click and choose "Assign Macro".

    2. Or do you want a button on the toolbar? Right-click the toolbar, choose "Customize". In dialog box, choose middle tab "Commands", on the left side scroll down to "Macros", select and then on right side choose "Custom Menu Item", click-drag it up to the toolbar, and relase when you see the dark vertical line. Then right-click the button, and choose "Assign macro". Right-click again and choose "Name" and put your custom name there.

    3. Or Forms toolbar buttons?

    4. Control Toolbox buttons?

    Each has advantages.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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