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
 
Top