+ Reply to Thread
Results 1 to 3 of 3

open to worksheet

  1. #1
    sarah
    Guest

    open to worksheet

    I would like to get my workbook to open to a certain
    worksheet and focus on cell b2.

    how do i make it do this.

    thanks

    Sarah

  2. #2
    Dave Peterson
    Guest

    Re: open to worksheet

    If you save the workbook that way (Sheetx active and B2 selected), it'll open
    that way.

    Or you could use a macro that runs when you open the workbook:

    sub Auto_Open()
    application.goto worksheets("sheetX").range("b2"), scroll:=true
    end sub

    And if you're new to macros, you may want to read David's intro:
    http://www.mvps.org/dmcritchie/excel/getstarted.htm

    sarah wrote:
    >
    > I would like to get my workbook to open to a certain
    > worksheet and focus on cell b2.
    >
    > how do i make it do this.
    >
    > thanks
    >
    > Sarah


    --

    Dave Peterson

  3. #3
    Arla M
    Guest

    RE: open to worksheet

    Your file will open to the same worksheet and cell that you leave it on, upon
    closing it. So just leave your cursor on Cell B2 on the sheet that you want
    -- Hit Save, and your done.

    Arla

    "sarah" wrote:

    > I would like to get my workbook to open to a certain
    > worksheet and focus on cell b2.
    >
    > how do i make it do this.
    >
    > thanks
    >
    > Sarah
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1