Invisible Application/Visible Forms?

[roy_ware]

The project for which you have all provided a great dela of invaluable help
is nearly at an end.

My last problem is how to hide Excel while keeping the forms in the task bar
as they are opened and closed. The goal is to make Excel invisible to the
user, yet still give them the opportunity to see this as a normal program.

I hide Excel in the splash box with the command "Application.Visible =
False". This works great.

However, none of my forms show up in the task bar as they are being
executed, even when I code "Application.ShowWindowsInTaskbar = True" in the
UserForm_Activate of every form (there's 10 forms in the application).

I suspect Application.Visible = False is the culprit. Is there a work
around for this? I really don't want the user to have access to the
underlying workbook.

 

[Chip Pearson]

You can set the Visible property of the Application to False:

Application.Visible = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[roy_ware]

Yes, that command is at the beginning of my program in the Splash Screen
code. That hides the spreadsheet nicely.

The problem is that the forms (Main Menu, Add New Information, Change
Information, Report Menu) do not appear in the task bar. I really would like
to have them appear in the task bar.

 

[roy_ware]

I found the solution at this site:

http://puremis.net/excel/code/063.shtml