Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Application false true.... (2000 sr 1)

    i have included into workbook open event this code.
    But when i open these wbook with this code, and i have already have a session of excel opened, the opened session is hide..., how to show only the userform and not close the other session of excel opened?

    Sub AUTO_OPEN()

    Application.Visible = False

    MODIFICHE.Show

    Application.DisplayAlerts = False
    End Sub

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

    Re: Application false true.... (2000 sr 1)

    Application is the entire Excel application. Try

    ActiveWindow.Visible = False

Posting Permissions

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