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

Hi Sandy,

try the following:

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


Zantor



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Thanks, Zantor!

Sandy

-----Original Message-----
Hi Sandy,

try the following:

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


Zantor



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.