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