Splash Screen Causing Problems
Perhaps post a code snippet from your add-in, specifically code related to
the opening events and your userform?
Keith
"Kevin R" wrote in message
...
I've already went that route and its not the problem in this case. I just
can't seem to figure out why this is happening. Thanks for the
suggestions.
"Tom Ogilvy" wrote:
the usual suggestions for problems like this not involving splash
screens is
to look in tools=Options and insure Ignore Other Applications is not
checked.
the second suggestion is to close excel and go to the windows start menu
and
select the run command. Put in
excel.exe /regserver
and click OK. This should refresh excels registry settings.
Perhaps it will help in your case.
--
Regards,
Tom Ogilvy
"Kevin R" wrote in message
...
The splash screen is part of a add-in that contains specially created
toolbars and macros to run against various excel files. These
toolbars
and
splash screen loads whenever excel is opened. When opening a file
from
explorer by double clicking without first opening excel, the splash
screen
shows, the toolbars load, but the file itself doesn't show, only a
gray
background as if no file is open. If I take the Userform1.Show out of
the
code, the file loads just fine. Not sure why the userform is not
allowing
the file to load.
"Tom Ogilvy" wrote:
No any. It would only be those files containing a splash screen
that
are
exhibiting this behavior.
--
Regards,
Tom Ogilvy
"Kevin R" wrote in message
...
How do I unhide it with code? The file opened could be any given
excel
file.
Thanks.
"Tom Ogilvy" wrote:
If the splash screen appears, the file is open. Perhaps it is
hidden.
If
so, unhide it with your code.
--
Regards,
Tom Ogilvy
"Kevin R" wrote in message
...
I have an xla file that contains a splash screen (userform) in
the
workbook_open event. This seems to be causing a problem when
opening
files
directly from windows explorer. If Excel is closed and I open
a
file
through
windows explorer, the splash screen appears but the xls file
does
not
open.
I have to open all files using the File | Open method or first
open
Excel
and
then open the files through windows explorer. If I take out
the
splash
screen I don't have the problem. Any ideas or suggestions on
how
to
correct
this so that files can be open directly from explorer without
having
to
first
open Excel? Thanks.
|