open to worksheet

  • Thread starter Thread starter sarah
  • Start date Start date
S

sarah

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
 
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
 
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
 
Back
Top