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