Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
splash screen | Excel Discussion (Misc queries) | |||
splash screen | Excel Discussion (Misc queries) | |||
splash screen | Excel Programming | |||
Splash screen and various screen resolutions | Excel Programming | |||
Splash Screen | Excel Programming |