+ Reply to Thread
Results 1 to 3 of 3

Thread: Marco Button

  1. #1
    Registered User
    Join Date
    11-16-2009
    Location
    Doncaster, England
    MS-Off Ver
    Excel 2000
    Posts
    26

    Marco Button

    Hi all,
    How do I create a button to run a macro in MS Word that is not on the tool bar but is on the page.
    I used the control toolbox option to draw a command button which I created just like using excel really but when I right clicked it does not give the option to assign a macro

    How do I attach a macro to this command button or is there a different button or can I assign a Marco to or an image so when you click the image it runs the macro?

    What ever is easier really.

    Any help would be appreciated thank you.
    Last edited by garethtaylor; 12-11-2009 at 05:32 AM.

  2. #2
    Forum Moderator teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    2003 & 2010
    Posts
    10,042

    Re: Marco Button

    Hi,

    In Excel you have the Control Toolbar buttons and the Forms toolbar buttons. The latter allows you to right click and assign a macro to the button.

    In Word, the Forms Toolbar does not offer a button, so there's no right click option to assign a macro.
    If you use the Control toolbar button, you'll need to enable design mode (click on the icon with the ruler and pencil on the Control Toolbar, then double click the button. This will open up the VBE with the button sub activated. Post your code into that sub or simply call the sub you've already created.

    hth
    teylyn
    Microsoft MVP - Excel
    At Excelforum, you can say "Thank you!" by clicking the icon below the post.

    Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.

  3. #3
    Registered User
    Join Date
    11-16-2009
    Location
    Doncaster, England
    MS-Off Ver
    Excel 2000
    Posts
    26

    Re: Marco Button

    thank you i had already done it then just needed to unclick that ruler button thankyou for the help

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.2.0