Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Excel Window

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jason Zischke - 24 Jan 2006 22:26 GMT
Hi all,

I'm looking for the API Calls for the excel window to be hidden however I
still want the userforms to come up on the screen. If anybody can help me
that would be greatly appreciatly.

Jason
N10 - 24 Jan 2006 22:46 GMT
Hi Jason

Does this help you

Application.Visible = False

UserForm1.Show

Best N10

> Hi all,
>
[quoted text clipped - 3 lines]
>
> Jason
Jason Zischke - 24 Jan 2006 23:20 GMT
N10

Thanks That worked perfectly.

Jason Zischke

> Hi Jason
>
[quoted text clipped - 13 lines]
> >
> > Jason
Jim Thomlinson - 25 Jan 2006 00:06 GMT
Be careful doing this kind of thing. Some potential problems are:

In case of a crash your error handler has to bring the application back or
the user will loose other spreadsheets they may have been working on.

Users will believe that spreadsheets that they had open are gone and they
will try to reopen them. This will cause problems as they are already open in
the hidden instance.

If the user tries to open other spreadsheets they will open in the hidden
instance of Excel.

The user will open new instances of Excel and then when you re-activate the
original instance of Excel they will have two instances which can cuase some
difficulties.

I am not saying don't do it just be aware of the side effects of hiding the
application...
Signature

HTH...

Jim Thomlinson

> N10
>
[quoted text clipped - 19 lines]
> > >
> > > Jason
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.