ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Minimize worksheet but keep userform visible (https://www.excelbanter.com/excel-programming/404146-minimize-worksheet-but-keep-userform-visible.html)

Marc Forget

Minimize worksheet but keep userform visible
 
I have a workbook with a Stop Watch userform which helps me keep track of
time spent on different tasks. It works well but I cannot minimize the
workbook which contains the form without making the form disappear.

Is there a way to keep the form visible? I'm already using a modeless form
which allows me to move around and use other workbooks while keeping the form
visible. My problem is specifically about minimizing the workbook without
hiding the form.

Thank you.

Bob Phillips

Minimize worksheet but keep userform visible
 
Try making Excel app not visible instead of minimizing it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marc Forget" wrote in message
...
I have a workbook with a Stop Watch userform which helps me keep track of
time spent on different tasks. It works well but I cannot minimize the
workbook which contains the form without making the form disappear.

Is there a way to keep the form visible? I'm already using a modeless
form
which allows me to move around and use other workbooks while keeping the
form
visible. My problem is specifically about minimizing the workbook without
hiding the form.

Thank you.




Marc Forget

Minimize worksheet but keep userform visible
 
But if I make the application not visible and I have other workbooks open,
will that not hide everything that's already open?

"Bob Phillips" wrote:

Try making Excel app not visible instead of minimizing it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Marc Forget" wrote in message
...
I have a workbook with a Stop Watch userform which helps me keep track of
time spent on different tasks. It works well but I cannot minimize the
workbook which contains the form without making the form disappear.

Is there a way to keep the form visible? I'm already using a modeless
form
which allows me to move around and use other workbooks while keeping the
form
visible. My problem is specifically about minimizing the workbook without
hiding the form.

Thank you.






All times are GMT +1. The time now is 01:12 PM.

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