Maximising Excel (Excel 97)

[rgovett]

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?

[Andrew Cronnolly]

The following code should help if you incorporate it into your OnTime macro :<pre>Dim Winstate As Long
Winstate = Application.WindowState
Application.WindowState = xlMaximized
' Run you userform message code here
Application.WindowState = Winstate</pre>


Andrew C

[rgovett]

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

Ron