Making application invisible

  • Hi guys, I've created a nice form in XL using VB code. I'm looking at giving it that professional look so I can distribute it around the company I work for. I would like it to look like a stand alone program if this is possible. At the moment I using the following code in the excel workbook:

    Private Sub Workbook_Open()
    Application.Visible = False
    End Sub

    The problem with this is the application opens and shows for a brief second before hiding which doesn't look to good. Is there anyway to improve on this?

  • Re: Making application invisible


    It's my opinon but!! Making the application invisible is NOT a good idea. If you must do so I think the best method would be to.

    1. Hide the active window.
    2. Activate the view "FullScreen"
    3. Search for methods which will when a form shows resize itself to fit the screen.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!