Event to set sheet and cell on open file
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Event to set sheet and cell on open file

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    357
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a workbook with a few sheets.

    I want the workbook upon opening the file to go to a particular sheet and a particular cell on that sheet.

    Sheet name = "Search"
    Cell = A2

    How do I do this with with an Excel Event?

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    1. Open the VBE (ALT+F11)
    2. Double click on "ThisWorkbook"
    3. In the edit window, click on the drop down on the left hand side and select "Workbook". (The code for the Workbook Open Event will appear)

    Stick in this code:


    Sheets("Search").Activate
    Activesheet.Range("A2").Select


    HTH

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    357
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks!! Works great!

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
  •  

 

 
DMCA.com