XL2000: Macro Cannot Scroll Chart Sheet (213662)
The information in this article applies to:
This article was previously published under Q213662 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
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.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are 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.
REFERENCESFor 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.
| Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
|---|
| Keywords: | kbbug kbdtacode kberrmsg kbnofix kbProgramming KB213662 |
|---|
|