Need code - scrollbars when document opens
 

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

Need code - scrollbars when document opens
 

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
--

"Sandy" wrote in message
...
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


.