Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    consolidate macros (2003)

    I have 5 macros for each of my worksheet (tab) and was wondering if there is a way that I can create 1 macro to run all five of these macros consecutively. I want to give the user that option.

    Thank you for your time and effort.

  2. #2
    Star Lounger
    Join Date
    Dec 2007
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: consolidate macros (2003)

    Thank you for you help. I'll give it a try.

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: consolidate macros (2003)

    <P ID="edit" class=small>(Edited by mbarron on 17-Aug-08 21:14. Macro did not end correctly the first time (no End Sub))</P>You can do something as simple as


    Sub all()
    Dim runAll As Variant
    runAll = MsgBox("Run all of the macros?", vbYesNo)
    If runAll = vbYes Then

    macro1
    macro2
    macro3
    macro4
    macro5

    Else

    do something else <not real code <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

    End If

    End Sub

Posting Permissions

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