Can't Step Through Macro with ActiveWindow.ActivateNext
Article ID: 134258
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 95 Standard Edition
This article was previously published under Q134258
SYMPTOMS
In Microsoft Excel, when you use the Activewindow.ActivateNext command in a
macro, and if you step through the macro, the active window does not
change.
WORKAROUND
To work around this problem, use the Index property to move to the next
window.
Sample Visual Basic Code
Microsoft provides examples of Visual Basic procedures for illustration
only, without warranty either expressed or implied, including but not
limited to the implied warranties of merchantability and/or fitness for a
particular purpose. This Visual Basic procedure is provided 'as is' and
Microsoft does not guarantee that it can be used in all situations.
Microsoft does not support modifications of this procedure to suit customer
requirements for a particular purpose.
Sub Test()
'Make the next window the active window
Windows(ActiveWindow.Index+1).Activate
End Sub
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
Additional query words: XL7
Keywords: kbprogramming KB134258