Making application invisible

thelocaluk · Dec 7th 2005

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:

Code

Private Sub Workbook_Open()
Application.Visible = False
frmSplash.Show
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?
Thanks

ChrisBEE1 · Dec 8th 2005

Re: Making application invisible

Hello thelocaluk:

You should take a look at Dave Hawley's presentation, entitled Creating a Splashscreen for your Excel Workbook at http://www.ozgrid.com/Excel/excel-splash-screen.htm.

Hope This Helps,
Chris

**iwrk4dedpr** · Dec 8th 2005

Re: Making application invisible

thelocaluk,

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.

Making application invisible

Participate now!

Share