Posted to microsoft.public.excel.programming

Robert Crandal Robert Crandal is offline

external usenet poster

Posts: 309

Set sheet viewpoint on workbook_open()

When Workbook_Open() is called, I want to tell Excel to
begin the viewpoint in the top left corner, starting at cell "A1".

A user will sometimes save their workbook while viewing
cells far below, such as "J200". When they re-open the
workbook, the workbook with open at cell "J200", but
I would rather have the sheet open at cell "A1". How do
I do this?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
workbook_Open	ernie	Excel Programming	3	June 12th 07 04:46 AM
Workbook_Open	Mangus Pyke	Excel Programming	13	September 12th 06 06:15 PM
Workbook_Open	Kevin R	Excel Programming	4	February 8th 05 12:53 PM
How to use workbook_open()?	Susan Hayes	Excel Programming	2	January 29th 05 03:43 PM
Help with Workbook_Open	Ruan[_3_]	Excel Programming	7	April 28th 04 07:52 AM

All times are GMT +1. The time now is 07:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us