Minimising window but not userform question

chrisp9au

New Member
Joined
Feb 13, 2015
Messages
8
To avoid confusing some elderly volunteers who are going to be entering data into a statistical gathering application,
I want to minimise the background Excel application window while displaying userforms for the data entry.

I have the necessary code for minimising the application window, but how do I keep the userforms visible?

Thanks, Chris
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Why not set the .Height and Width of the user form to BIG. (perhaps color it backgroundy) and put the controls in a foreground colored Frame.

Code:
Private Sub UserForm_Activate()
    Dim CurrentWindow As Window
    Set CurrentWindow = ThisWorkbook.Windows(1)
    With Me
        .Height = CurrentWindow.UsableHeight
        .Width = CurrentWindow.Width
        .Left = CurrentWindow.Left
        .Top = CurrentWindow.Top + CurrentWindow.Height - CurrentWindow.UsableHeight
    End With
End Sub
 
Upvote 0
Thanks for the suggestion, and the code.
My Userform application will be used on a wide screen monitor, and will only occupy a third of the screen.
Volunteers need to have other windows opening and closing as required, while keeping my application open all shift or the whole day.
I use an Auto Start routine for the application and would like to minimize the Excel window from that routine, just displaying the Userform.
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,103
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top