Maximising Excel (Excel 97)

Topic

New Reply

I have a workbook with some .onTime notifications popping up at intervals in a UserForm, when the userform is .Shown Excel may be minimised in which case the Taskbar button flashes and the user doesn’t see the userform until they maximise Excel .. how can I change this/ check if Excel is minimised, maximise it if needed and minimise it again?

Reply | Quote

Replies

The following code should help if you incorporate it into your OnTime macro :

Dim Winstate As Long
    Winstate = Application.WindowState
    Application.WindowState = xlMaximized
    ' Run you  userform message code here
    Application.WindowState = Winstate

Andrew C

Reply | Quote

Andrew, That works fine but is there a way to force Excel to the front of other open windows when it is maximised?

Ron

Reply | Quote