+ Reply to Thread
Results 1 to 4 of 4

Combine multiple Subs into Workbook_Open Sub

  1. #1
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Combine multiple Subs into Workbook_Open Sub

    Is there a way to combine multiple Sub Procedures into the Workbook_Open Sub. I am trying to get multiple subs to fire when the Workbook_Open Event is triggered. Right now I am only able to paste code within the Workbook_Open Sub to accomplish this. Thanks for the help.

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Combine multiple Subs into Workbook_Open Sub

    Any code can go into this subroutine. Including calls to other subroutines.

    Like This

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-20-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007, Excel 2003, Excel 2010
    Posts
    284

    Re: Combine multiple Subs into Workbook_Open Sub

    Thanks. So if the Sub in Module 1 is called Private Sub Auto_Update(), would it be Module1.Auto_Update. I think I tried that but it did not work. Not sure what I might be doing wrong. Thanks

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Combine multiple Subs into Workbook_Open Sub

    Hi rlsublime
    I believe you'll find that Private Subs are only available to Subs within the same module. If you wish to make it available to ThisWorkbook Module, change it to Public.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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