+ Reply to Thread
Results 1 to 5 of 5

Combining Macros

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    USA
    MS-Off Ver
    Office 97
    Posts
    43

    Combining Macros

    Hello. I have another newb question. How do I go about combining several macros into one button? I'm trying to clear some cells, while restoring other cells to a default value, all in the same button. Also, I'm not sure if I should be using
    Please Login or Register  to view this content.
    for the defaults given the way I'm trying to go about this. Here are the four macros I'm trying to combine.

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by Clue_Less; 06-12-2012 at 05:25 PM. Reason: typo

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Cobining Macros

    Hi Clue_Less,

    You'll have to have unique names for your macros - but then you can have them all in the same procedure by just naming them to whit:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    06-11-2012
    Location
    USA
    MS-Off Ver
    Office 97
    Posts
    43

    Re: Cobining Macros

    Ok, that sounds easy enough. How do I name them?

  4. #4
    Registered User
    Join Date
    06-11-2012
    Location
    USA
    MS-Off Ver
    Office 97
    Posts
    43

    Re: Combining Macros

    Nevermind, I get it now. I see how you name them. Sorry, I'm just completely new to this.

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Combining Macros

    OK - glad you've got it!

+ 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