View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sandy[_3_] Sandy[_3_] is offline
external usenet poster
 
Posts: 43
Default 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



.