My userform works perfectly as I have the module that includes the
minimize and close buttons and it is set to ShowModal=False; however,
is it possible for the Userform to be launched in a minimized state
when the worksheet is activated? I can set the location to the far
right which works fine for users that have a 22" monitor but there are
still some users sporting 15" monitors so it would be handier to have
it automatically minimized.

Any thoughts/suggestions are always appreciated.

You may want to consider including your code it makes it easier for others to
help you with your question.

"(E-Mail Removed)" wrote:

> My userform works perfectly as I have the module that includes the
> minimize and close buttons and it is set to ShowModal=False; however,
> is it possible for the Userform to be launched in a minimized state
> when the worksheet is activated? I can set the location to the far
> right which works fine for users that have a 22" monitor but there are
> still some users sporting 15" monitors so it would be handier to have
> it automatically minimized.
>
> Any thoughts/suggestions are always appreciated.
>