XL98: Macro Cannot Scroll Chart Sheet

• Microsoft Excel 98 Macintosh Edition

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, click the article number below to view the article in the Microsoft Knowledge Base:

Q176476 OFF: Office Assistant Not Answering Visual Basic Questions

Additional query words: XL98

Keywords : kberrmsg kbdta xlvbainfo
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug