Splash Screen

B

Bill

Hello,
I use a splash screen when a macro opens. Never had a problem with it. Now
a user with Excel 2000 had an error after enabling macros: Microsoft Excel
400 error which has to with showing a form. It was the splash screen. When
I bypassed showing the form, it worked for that user. It works fine showing
the splash screen with my Excel 2000.

Code:

In this workbook:


Private Sub Workbook_Open()
SplashSSS.Show
End Sub

In form:
Private Sub UserForm_Activate()
Application.OnTime Now + TimeValue("00:00:03"), "KilltheForm"
End Sub

In a module:

Public Sub KilltheForm()
Unload SplashSSS
End Sub

Any idea why this would generate an error?

Thanks.

Bill
 
B

Bob Phillips

I have Excel 2000 on this laptop, and your code worked fine here. Where does
the error occur?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
B

Bill

The error occurs immediately after he selects Enable Macros. He gets a
message saying file not found, then hits help and get the 400 error message.
Very strange since it works on lots of Excel 2000 versions just fine.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top