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
 
You must log in or register to reply here.

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
Slidebar (scrollbar) insertion through VBA 3
Keep the scrollbar at position 1
Code for scrollbar to go to top 3
Question about the TextBox control 1
Extreme newb, easy question: Simple button/scrollbar coding 1
FullScreen Mode Horizontal ScrollBar Missing 3
too many scrollbars 1

Back
Top