XL98: Macro Cannot Scroll Chart Sheet

ID: Q191154

The information in this article applies to:

SYMPTOMS

When you use either the SmallScroll or LargeScroll methods, you may receive an error message similar to the following:

   Run-time error '1004':

   SmallScroll method of Window class failed.

CAUSE

This error message may occur if a Chart sheet is active when your macro calls either the SmallScroll or LargeScroll method.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

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

REFERENCES

For more information about the SmallScroll Method, from the Visual Basic Editor, click the Office Assistant, type "smallscroll," click Search, and then click to view "SmallScroll Method."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q176476
   TITLE     : OFF: Office Assistant Not Answering Visual Basic Questions

Additional query words: XL98
Keywords          : kberrmsg kbdta xlvbainfo 
Version           : MACINTOSH:98
Platform          : MACINTOSH
Issue type        : kbbug
Solution Type     : kbnofix

Last Reviewed: August 12, 1998