XL: Macro Cannot Scroll Chart Windows

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

SUMMARY

In Microsoft Excel, you have the ability to scroll a chart window either vertically or horizontally. However, you cannot scroll a chart window from a Visual Basic for Applications procedure or from a macro.

MORE INFORMATION

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.

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.