+ Reply to Thread
Results 1 to 5 of 5

Assign macro to a buutton

  1. #1
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Assign macro to a buutton

    Ive created a button for a macro but have forgotten how to assign a macro to it ahhhhh ive not recorded in bout a year an have forgotten how to do it all help given i appreciate and thank you to you all

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Assign macro to a buutton

    Right Click on the button

    And select assign macro
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Assign macro to a buutton

    Right-click on the button and choose Assign Macro from the drop-down. From there, click on the macro name that you want to be associated with the button from the list provided, then OK.

    Hope this helps.

    Pete

  4. #4
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Re: Assign macro to a buutton

    Thank you - so easy cant believe i forgot it

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Assign macro to a buutton

    You don't say what kind of button you created. If it is a button from the Form Controls, you can right click as described above and assign the macro. However, if you inserted an AxtiveX control, this won't work.
    For an ActiveX button follow the instructions found here: https://support.office.com/en-us/art..._an_activex_co
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hidden macro names from Assign Macro Window
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-02-2016, 08:17 PM
  2. [SOLVED] Using macro to create a Form Control Button and Assign macro to it in a specified Cell
    By weige1989 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2014, 11:51 AM
  3. How to assign macro to buttons in another workbook where the source macro path not fixed?
    By rutikachavan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2013, 04:32 AM
  4. Replies: 0
    Last Post: 01-15-2013, 08:18 PM
  5. Assign a macro to automatically find the last assigned other macro
    By tperkins1973 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-03-2012, 06:39 PM
  6. [SOLVED] Write and assign macro to newly created button using macro
    By tryingtolearn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-19-2012, 10:41 PM
  7. Replies: 2
    Last Post: 01-18-2008, 11:45 AM

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.6.0 RC 1