+ Reply to Thread
Results 1 to 10 of 10

Default Sheet When Workbook Opens ...

  1. #1
    Forum Contributor
    Join Date
    07-02-2006
    Location
    Love City, USA
    Posts
    183

    Question Default Sheet When Workbook Opens ...

    Is there a way to have a certain or default sheet open everytime that workbook is opened?

    Example: I have a Sheet Labled 'Start', but i also have 10 other worksheets.

    Is it possible to have the worksheet labled 'Start' to open by default everytime
    this workbook is opened?

    Thanks for any help here...

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    Hi,

    You need an event macro in ThisWorkbook module ...
    Please Login or Register  to view this content.
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Contributor
    Join Date
    07-02-2006
    Location
    Love City, USA
    Posts
    183
    You're Excellent Carim! Thanks for the fast Respone...

    Your Knowledge is Greatly Appreciated... Thanks

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    Glad it fixed your problem

    Thanks for the feedback

  5. #5
    Forum Contributor
    Join Date
    07-02-2006
    Location
    Love City, USA
    Posts
    183
    Carim, when I close and open the workbook, the start page is not opening.

    does it have to be the first module code?

    thanks..

  6. #6
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    No ...

    As stated in my previous post, this event macro has to be stored into the module called "ThisWorkbook" ...

  7. #7
    Forum Contributor
    Join Date
    07-02-2006
    Location
    Love City, USA
    Posts
    183
    Hi Carim, I don't see a Module Named ThisWorkBook. Is it something I have to create?

    If so, How, And exactly where is this coding inserted in the module?

    Thanks..

  8. #8
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Every workbook has a ThisWorkbook module. Once you are in the VB Editor (ALT + F11), see attached picture.
    Attached Images Attached Images

  9. #9
    Forum Contributor
    Join Date
    07-02-2006
    Location
    Love City, USA
    Posts
    183

    Thumbs up

    A BIG Thanks to you Carim and jasoncw on this topic. It works great now
    that I realize how to access the ThisWorkBook module.. Thank you all very much..

    The Image was also helpful..thanks alot..

  10. #10
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    You're welcome.

+ 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