XL2000: Macro Cannot Scroll Chart Sheet

• Microsoft Excel 2000

SYMPTOMS

When you use either the SmallScroll or LargeScroll methods in a Microsoft Visual Basic for Applications Sub procedure, you may receive an error message similar to one of the following:

Run-time error '1004':
SmallScroll method of Window class failed

-or-

Run-time error '1004':
LargeScroll method of Window class failed

CAUSE

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

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

In Visual Basic for Applications, you can use the SmallScroll and LargeScroll methods to scroll a worksheet or an 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.

REFERENCES

For more information about the SmallScroll method, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type SmallScroll Method in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: xl2000

Keywords : kbprg kbdta kbdtacode OffVBA PgmOthr PgmHowto KbVBA
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug