Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Location
    Monroeville, Pennsylvania, USA
    Posts
    152
    Thanks
    0
    Thanked 0 Times in 0 Posts

    open page (2002/xp)

    How does one open a certain page of a workbook every time the workbook is opened? ie: sheet 3

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: open page (2002/xp)

    You can create a macro that runs everytime the workbook opens. Within the visual basic editor it needs to be placed in the ThisWorkbook section.

    You can use either of the following:

    The first version uses the name of the sheet & will cause an error if the sheet is renamed.

    <code>Private Sub Workbook_Open()</code>
    <code> Sheets("Sheet3").Select</code>
    <code>End Sub</code>
    <code></code>


    The 2nd option will still work if the sheet is renamed. Sheet3 in this case is not the name shown on the tab but is the sheet code name. For a discussion on the differences see OzGrid

    <code>Private Sub Workbook_Open()</code>
    <code> Sheet3.Select</code>
    <code>End Sub</code>

Posting Permissions

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