Posted to microsoft.public.excel.programming

ordnance1

external usenet poster

Posts: 52

Creating a common starting point

I run the code below to ensure that all worksheets are set to a 100% zoom and
that cell A3 is selected on all worksheets. Is ther also a way to ensure that
all worksheets are scrolled all of the way to the top?

Sheets(Array("January", "February", "March", "April", "May", "June", "July",
"August", _
"September", "October", "November", "December")).Select
Sheets("January").Activate
Range("A3").Select
ActiveWindow.Zoom = 100
Sheets("January").Select

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
Return to starting point	Patrick C. Simonds	Excel Programming	6	July 18th 09 07:03 PM
Return to starting point	Patrick C. Simonds	Excel Programming	1	December 6th 08 07:55 PM
Go back to starting point	PeterW[_13_]	Excel Programming	2	August 16th 06 01:57 PM
bar chart starting point	lnoles	Charts and Charting in Excel	1	October 14th 05 02:16 PM
Starting Point of macro	Turin	Excel Programming	1	July 7th 05 12:51 PM

All times are GMT +1. The time now is 10:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us