Microsoft KB Archive/106004

= Macro Cannot Scroll Chart Sheet =

Article ID: 106004

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q106004



SUMMARY
In Microsoft Excel, you can scroll a chart window either vertically or horizontally. However, you cannot scroll a chart window from a Microsoft Visual Basic for Applications procedure or from a macro.



Microsoft Excel Versions 5.0 and Later
In Visual Basic, you can use the SmallScroll and LargeScroll methods to scroll a worksheet or a Microsoft Excel macro sheet window. Each method accepts up to four arguments, indicating the number of rows or columns to scroll down, up, right, and left.

Microsoft Excel Versions 4.0, 5.0, and 7.0
In a Microsoft Excel 4.0 macro, you can use any of six functions to scroll a worksheet or a Microsoft Excel 4.0 macro sheet:   This macro function   Does this --

VLINE                Scrolls vertically through the active window by the number of rows specified.

VPAGE                Scrolls vertically through the active window by the number of windows specified ("window"                        defined as the number of rows visible at any                         given time).

VSCROLL              Scrolls vertically through the active window to the row specified. The HLINE, HPAGE, and HSCROLL functions work similarly, but these functions scroll the window horizontally instead of vertically.

If you attempt to use any of the above methods or functions when the active window is a chart window, you will receive an error message. This limitation does not affect other macro functions or methods because items in charts do not need to be visible in order to be affected by macros in Microsoft Excel.

Additional query words: 5.00a 5.00c XL

Keywords: kbhowto kbprogramming KB106004

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.