Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open a workbook with a specific worksheet displayed by defa | New Users to Excel | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Is there a way to make Excel 2000 open a new worksheet in a new w. | Excel Discussion (Misc queries) | |||
cannot open inserted objected in worksheet | Excel Discussion (Misc queries) | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) |