Need code - scrollbars when document opens

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Hello!

I have code that places the selects Cell E5 when a
document is open. I thought that would automatically set
the scrollbars, but it doesn't.

I want the horizontal scrollbar to go completely to the
left on open and the vertical scrollbar to be completely
at the top of the document.

I searched help, but all I could find was setting
scrollbars on a form.

Any help you can give will be greatly appreciated!

Sandy
 
Thanks, Don!

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

See:-

Activewindow.DisplayHorizontalScrollBar = False (True)
ActiveWindow.DisplayVerticalScrollBar = False (True)

The above hide (show) the scrollbars.

The position indicated by the scrollbars depends on the scrollable area.

See ActiveSheet.ScrollArea

regards,
Don
--




.
Click to expand...
 
Back
Top