Results 1 to 4 of 4

Activate First Worksheet

This is a discussion on Activate First Worksheet within the Excel Questions forums, part of the Question Forums category; Hi All I am creating a macro to ensure that when the workbook opens it always opens on the first ...

  1. #1
    New Member
    Join Date
    Dec 2003
    Location
    Western Australia
    Posts
    42

    Default Activate First Worksheet

    Hi All

    I am creating a macro to ensure that when the workbook opens it always opens on the first worksheet in the workbook. This worksheet will constantly have a different name so the line "Sheets("First Worksheet Name").Select" which I originally wrote will not work.

    Can anyone advise the code so that the firstwork sheet is active on opening.

    Tanks

    DM

  2. #2
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    sheets(1).activate

  3. #3
    Board Regular
    Join Date
    Jan 2004
    Location
    Melbourne
    Posts
    3,459

    Default Re: Activate First Worksheet

    worksheets(1).select will work.

    You can relace the "1" with the number of the sheet you want (counting left to right)
    There are three kinds of people - those that can count and those that can't.

  4. #4
    New Member
    Join Date
    Dec 2003
    Location
    Western Australia
    Posts
    42

    Default Re: Activate First Worksheet

    Champion!



    Easy for the gurus.

    Cheers

    DM

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
  •  


DMCA.com