Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Australia
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Maximising Excel (Excel 97)

    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?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Maximising Excel (Excel 97)

    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

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    Australia
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximising Excel (Excel 97)

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

    Ron

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •