Results 1 to 3 of 3

Thread: Default Cell position?

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Default Cell position?

    I wish to open a spreadsheet file and have the cursor be in the very 1st cell or not even show the cursor at all. How can this be done?

    Thanks,

    Blake

  2. #2
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Re: Default Cell position?

    Using the Workbook_Open sub should do it. In VBE, place the following on ThisWorkBook:

    VB Code:
    1. Private Sub Workbook_Open()
    2.     Range("A1").Select
    3. End Sub

    VBAhack

  3. #3

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Re: Default Cell position?

    Thanks hack....that worked!!!!!

Posting Permissions

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



Click Here to Expand Forum to Full Width