Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Set a worksheet to open

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Northern Ireland
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I set a specific worksheet to open when I open a workbook?

    It always opens with whatever the last sheet was that I looked at.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In the Workbook area, you need something like...

    Private Sub Workbook_Open()
    Sheets("yoursheetname").Select
    End Sub

    Rgds
    AJ

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Northern Ireland
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Gosh I feel such a dork, I could not see the workbook area.

    Thanks anyway

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Put this code (modify for your sheet name) in the "ThisWorkbook" section in excel VB:

    Private Sub Workbook_Open()
    Sheets("Sheet1").Activate
    End Sub

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a command line for opening specific worksheets in a workbook when opening excel. You can specify in icon properties a workbook to open. Can you also tell excel which worksheet of the workbook to open as well?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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