Need code - scrollbars on workbook open

S

Sandy

Hello!

I have code that selects cell E5 of a certain sheet on
opening a workbook. Thought that would work to position
the scrollbars too, but it doesn't.

I need also to have the horizontal scrollbar completely to
the left at startup and the vertial scrollbar at the top.

Does anyone know how to put this in code?

Sandy
 
Z

zantor

Hi Sandy,

try the following:

Range("E5").Select
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1


Zantor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need code - scrollbars when document opens 1
Resizing the Details Section Height and Width. 1
Sheet tabs & horizontal scrollbar disappeared - Excel 2003 3
Position Userform In Cells Portion of Excel Only 1
inserting scrollbar inside an Excel Sheet 3
Protecting an Excel worksheet without locking the embedded scrollbar 4
Help implementing Steven Lebans' Get/Set Scrollbars with GetCurren 1
FullScreen Mode Horizontal ScrollBar Missing 3

Top