Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel opens, but document doesn't | Setting up and Configuration of Excel | |||
Excel Document opens twice | Setting up and Configuration of Excel | |||
Excel opens with the file I want plus a new, blank document? | Setting up and Configuration of Excel | |||
My document opens but all I see is a grey screen. | Excel Discussion (Misc queries) | |||
add a menu bar when document opens | Excel Programming |