+ Reply to Thread
Results 1 to 5 of 5

Assign more than 1 macro to 1 button

  1. #1
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Birmingham, UK
    MS-Off Ver
    2007
    Posts
    185

    Assign more than 1 macro to 1 button

    Hello,

    It may be a lame question but I have a document which requires two or three macros to be recorded. Then I need to run all them before saving the document and it would be a lot better to have only one button.

    This document will be used by other users and I want to make sure that they will not get confused and won't make mistakes.

    If anyone has an idea please let me know if it can be done.

    Thanks for looking at the issue.

    Simon
    Last edited by dominicb; 03-16-2010 at 10:48 AM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Can I assigne more than 1 macro to 1 button?

    You can just use another macro to call the ones you want in turn and attach that to the button.

    Please Login or Register  to view this content.
    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Can I assigne more than 1 macro to 1 button?

    Quote Originally Posted by Ramzes View Post
    Hello,

    It may be a lame question but I have a document which requires two or three macros to be recorded. Then I need to run all them before saving the document and it would be a lot better to have only one button.

    This document will be used by other users and I want to make sure that they will not get confused and won't make mistakes.

    If anyone has an idea please let me know if it can be done.

    Thanks for looking at the issue.

    Simon
    You can take a look here http://www.thecodecage.com/forumz/do...-new-post.html i've create a small snippet of code to do what you need, it just needs adapting.
    Not all forums are the same - seek and you shall find

  4. #4
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Birmingham, UK
    MS-Off Ver
    2007
    Posts
    185

    Re: Can I assigne more than 1 macro to 1 button?

    Worked perfectly the suggestion with calling each one in a code.

    Many thanks for your help guys.

  5. #5
    Forum Contributor
    Join Date
    12-02-2009
    Location
    Birmingham, UK
    MS-Off Ver
    2007
    Posts
    185

    Re: Can I assigne more than 1 macro to 1 button?

    Can someone from the Moderators or Administrators mark this thread as Solved, as it does. not allow me to do so.

    Thank you.
    Simon

+ Reply to Thread

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