ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Activate Sheet but minimize Userform (https://www.excelbanter.com/excel-programming/426956-activate-sheet-but-minimize-userform.html)

[email protected]

Activate Sheet but minimize Userform
 
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.

Dan Thompson

Activate Sheet but minimize Userform
 
You may want to consider including your code it makes it easier for others to
help you with your question.

" 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.



All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com