XL98: Macro Cannot Scroll Chart Sheet (191154)



The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition

This article was previously published under Q191154

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."


Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug kberrmsg KB191154