LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Invisible Application/Visible Forms?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make a chart axis visible/invisible with VBA Jeff Reese Charts and Charting in Excel 3 April 27th 23 03:42 AM
Make chart axis visible/invisible with VBA Jeff Reese Excel Programming 1 March 21st 07 08:28 PM
makeing the pictures visible or invisible 2007-User Excel Programming 6 August 31st 06 01:44 AM
change invisible bars back to visible hf Charts and Charting in Excel 1 July 28th 06 02:29 PM
invisible text boxes becoming visible Jordan Excel Programming 1 February 26th 05 12:01 AM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"