Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically going to cell when spreadsheet opens (2000)

    Is is possible to assign a macro to go to a specific cell in a spreadsheet when the spreadsheet loads up?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Automatically going to cell when spreadsheet opens (2000)

    Activate the Visual Basic Editor (Alt+F11)
    Double click ThisWorkbook.
    Enter code like this:

    Private Sub Workbook_Open()
    Worksheets("Sheet3").Select
    Range("P2").Select
    End Sub

    Of course, you should substitute the appropriate sheet name and cell address.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Automatically going to cell when spreadsheet opens (2000)

    Right click on the sheet tab and choose View Code.
    You will see two drop downs on the top of the window.
    Select Worksheet from the first and select Activate from the second.
    Inside the Private Sub Worksheet_Activate() procedure type: Range("A1").Select

    (Change the range reference as needed!)
    Regards,
    Rudi

  4. #4
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically going to cell when spreadsheet o

    Thats great thanks.

Posting Permissions

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