Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    ShowModal (Excel 2000)

    Hi all
    Is there a way to show a form with the Excel Application Minimized, Or should I be using VB6?

    Thanks
    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ShowModal (Excel 2000)

    There may be a trick using Windows API functions., but as far as I know it's not possible using Excel VBA only.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ShowModal (Excel 2000)

    I don't think so, the userform would be minimized with Excel. You can do this though:

    <pre> Application.Visible = False
    UserForm1.Show
    </pre>

    Legare Coleman

  4. #4
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: ShowModal (Excel 2000)

    Where would I insert that code?

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ShowModal (Excel 2000)

    Where you want to show the userform without Excel being visible. And someplace before the userform goes away, you better have:

    <pre> Application.Visible = True
    </pre>

    Legare Coleman

Posting Permissions

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