How do you find it now? Aren't some, maybe all, the other workbook window in
the way and you have to move/minimize/whatever them to get to the one you
want? One or more quick presses of Ctrl+Tab (which can be done with one
hand, so your other hand can remain on the mouse) and you are there. Also,
if you have a sense of the order your workbooks were opened in, you can use
Shift+Ctrl+Tab (also doable with one hand) to move backward through the
workbook ordering.

Rick


"expect_ed" wrote in message
...
That really is not much help when i have 10 workbooks open and want to get
to
the 5th one.
Anyone have any help on the actual request?
Thanks
ed

"Rick Rothstein (MVP - VB)" wrote:

If you keep them all maximized, you can use Ctrl+Tab to switch between
your
open workbooks.

Rick


"expect_ed" wrote in message
...
I keep multiple worksheets open in the Excel window not maximized so I
can
easily click from one to another without always pulling down a menu.
Often
when I open another worksheet it is sized quite a bit larger than the
Excel
workspace and I have to drag the borders several times to get it to a
size
where i can see the sroll bars. I would like a macro that would resize
the
current worksheet to be just slightly smaller in all directions than
the
Excel workspace, regardless of how large the overall Excel window
currently
is (I work on dual monitors and the Excel window might be maximized or
not
in
either monitor, which are different sizes).

Any ideas?

Thanks in advance for your help.
ed