David,
If you are referring to the size of the window containing the userform when
designing, then no, unless you want to write an add-in to do it for you.
However, for me (XL2K+XL2002), the size of the window remains the same after
opening/closing the window and/or the file.

NickHK

"#DIV/0" wrote in message
...
Does anyone know of a way to force the frame of a UserForm window to be
closer to the size of the form you're working on ?
It gets really annoying when you have 4 or 5 forms in a project and every
time you open the form again the window is so much larger than necessary.
I
seem to spend a lot of time grabbing the corners of windows to resize
them...

--
David M

Yes, Nick, that's what I meant. I have WinXP and Office 2003.
If I close the window containing the form then reopen it during the same
session, it "remembers" the size I set. But after closing and reopening the
project I get huge windows again.
It doesn't make work impossible but it's one of those little annoyances. I
guess I was hoping for something like VBScroll, a little app that overcomes
that other stupidity - no scrolling in the code windows.

--
David M


"NickHK" wrote:

David,
If you are referring to the size of the window containing the userform when
designing, then no, unless you want to write an add-in to do it for you.
However, for me (XL2K+XL2002), the size of the window remains the same after
opening/closing the window and/or the file.

NickHK

"#DIV/0" wrote in message
...
Does anyone know of a way to force the frame of a UserForm window to be
closer to the size of the form you're working on ?
It gets really annoying when you have 4 or 5 forms in a project and every
time you open the form again the window is so much larger than necessary.
I
seem to spend a lot of time grabbing the corners of windows to resize
them...

--
David M

David,
May be a 2003 thing as previous versions keep the window size after closing,
on my system anyway.

NickHK

"#DIV/0" wrote in message
...
Yes, Nick, that's what I meant. I have WinXP and Office 2003.
If I close the window containing the form then reopen it during the same
session, it "remembers" the size I set. But after closing and reopening
the
project I get huge windows again.
It doesn't make work impossible but it's one of those little annoyances. I
guess I was hoping for something like VBScroll, a little app that
overcomes
that other stupidity - no scrolling in the code windows.

--
David M


"NickHK" wrote:

David,
If you are referring to the size of the window containing the userform
when
designing, then no, unless you want to write an add-in to do it for you.
However, for me (XL2K+XL2002), the size of the window remains the same
after
opening/closing the window and/or the file.

NickHK

"#DIV/0" wrote in message
...
Does anyone know of a way to force the frame of a UserForm window to
be
closer to the size of the form you're working on ?
It gets really annoying when you have 4 or 5 forms in a project and
every
time you open the form again the window is so much larger than
necessary.
I
seem to spend a lot of time grabbing the corners of windows to resize
them...

--
David M