Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel window won't restore down. (Excel 97)

    Hi,

    I hope someone can help me, I have one user who is using Excel 97 (part of Office 97 Sp2) on a Windows 2000 machine.

    When he tries to restore down the whole Excel window it minimises the whole application and doesn't just restore down to a smaller window.

    However, when I logon it works ok for me, but it is not to do with his profile as I have asked him to logon to another PC which he did so and it worked fine.

    If anyone has any suggestions or has come across this problem I'd be very grateful for yor help.

    Thanks

    Kevin

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel window won't restore down. (Excel 97)

    Try this macro:

    Application.windowstate=xlNormal
    application.Width=100
    application.Height=100
    application.Top=0
    application.Left=0
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel window won't restore down. (Excel 97)

    Thanks very much for the idea, I'll give it a go...

    Kevin

  4. #4
    New Lounger
    Join Date
    Jan 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel window won't restore down. (Excel 97)

    It worked perfectly!

    Thank-you very very much for your help...

    Kevin

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel window won't restore down. (Excel 97)

    Great to hear this worked.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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