Need code - scrollbars on workbook open

  • Thread starter Thread starter Sandy
  • Start date Start date
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
 
Hi Sandy,

try the following:

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


Zantor
 
Back
Top