Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / February 2005

Tip: Looking for answers? Try searching our database.

open to worksheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sarah - 05 Feb 2005 22:40 GMT
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 - 05 Feb 2005 23:03 GMT
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

> I would like to get my workbook to open to a certain
> worksheet and focus on cell b2.
[quoted text clipped - 4 lines]
>
> Sarah

Signature

Dave Peterson

Arla M - 05 Feb 2005 23:07 GMT
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

> I would like to get my workbook to open to a certain
> worksheet and focus on cell b2.
[quoted text clipped - 4 lines]
>
> Sarah
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.