I have an application that requires one of my excel sessions to be hidden
For some reason (and it happens rarely) the current hidden app can not be made visible..HTML Code:
Is there a VBA workaround to get the app out of hiding?
I have an application that requires one of my excel sessions to be hidden
For some reason (and it happens rarely) the current hidden app can not be made visible..HTML Code:
Is there a VBA workaround to get the app out of hiding?
Last edited by SDruley; 06-22-2011 at 07:43 AM.
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
What do you mean the hidden app can not be made visible?
To make a hidden app visible, you can type into the immediate window:
and hit Enter.![]()
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
How did it get invisible.
In these cases I use:
Which offers me the opportunity to switch between visible/not-visible whenever I like, because there's always a connection to this workbook.![]()
Please Login or Register to view this content.
In other cases you should use
![]()
Please Login or Register to view this content.
Let me explain better. I have two excel sessions running,,, session A and session B.Session A contains two Workbooks and Session B contains one Workbook. For some reason, at the session level, Session B will become "B.Visible=false", or unavailable. When this happens any code that refers to session B will indicate the the object has not been set. A sample of my declarations is as follows:
xlLINKx and its workbook LinkUP and the worksheet LKD become invisible since the session in which they reside becomes invisible.![]()
Please Login or Register to view this content.
The only way to correct this is to reboot.
The only code I use in the program that refers to the word visible is in the following subroutine:
I just do not understand what is happening.![]()
Please Login or Register to view this content.
It looks intriguing.
Why don't you use
instead of:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Last edited by snb; 06-22-2011 at 09:56 AM.
snb,
I will try this on my next revision... will let you know. I looks like it will improve communications and is a cleaner approach.
Steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks