Quickly Changing Windows

If you routinely use several open workbooks to do your work, you already know that you can change between workbook windows by choosing the workbook name from the Window menu. You may not know, however, that there is a shortcut for changing windows. You can cycle through your documents by pressing either Ctrl+F6 or Shift+Ctrl+F6. The difference is that Ctrl+F6 cycles through the list of windows in a forwards direction, while Shift+Ctrl+F6.

If you would rather not take your hands off the mouse, you can create a macro which cycles through the windows. This macro can then be assigned to a button on one of your toolbars. The following macro will do the trick:

Sub ChangeWin()
    On Error GoTo ChangeWinErr
    Set nw = ActiveWindow.ActivateNext
    If Windows.Count > 1 Then
        nw.Activate
        Exit Sub
    End If
    ChangeWinErr:
        Windows(1).Activate
End Sub