Creating Splash Screen in Excel 2004 MacIntosh

[Bill]

I have created a splash screen that works fine in Windows Excel but not on a
MacIntosh. I am using Application.wait to have the splash screen appear for
five seconds but on the Mac it will not disappear. From my testing it appears
that on the Mac the splash screen is being treated as a modal dialog box so
the five second timer does not start until after the user has manually closed
it. I have looked at the properites but can't see any place to set it to
non-modal.

Any suggestions on how to change this.

TIA

Bill

 

[Jim Rech]

I know nothing about Excel on Macs but here's an alternate method that works
on PCs and may on Macs.

Sub ShowUF()
Application.OnTime DateAdd("s", 5, Now), "CloseUF"
UserForm1.Show
End Sub

Sub CloseUF()
Unload UserForm1
''Other stuff
End Sub


--
Jim
|I have created a splash screen that works fine in Windows Excel but not on
a
| MacIntosh. I am using Application.wait to have the splash screen appear
for
| five seconds but on the Mac it will not disappear. From my testing it
appears
| that on the Mac the splash screen is being treated as a modal dialog box
so
| the five second timer does not start until after the user has manually
closed
| it. I have looked at the properites but can't see any place to set it to
| non-modal.
|
| Any suggestions on how to change this.
|
| TIA
|
| Bill

 

[Bill]

Hi Jim:

Thanks for the suggestion. I tried it but it seems to work the same way the
Application.Wait method does; once the Show method has been invoked the
program halts execution until the form is closed.

Bill

 

[Jim Rech]

Ah, the things you don't see in Mac TV commercials<g>.

I suppose explicitly showing the form modeless fails too?

UserForm1.Show vbModeless

--
Jim
| Hi Jim:
|
| Thanks for the suggestion. I tried it but it seems to work the same way
the
| Application.Wait method does; once the Show method has been invoked the
| program halts execution until the form is closed.
|
| Bill
|
| "Jim Rech" wrote:
|
| > I know nothing about Excel on Macs but here's an alternate method that
works
| > on PCs and may on Macs.
| >
| > Sub ShowUF()
| > Application.OnTime DateAdd("s", 5, Now), "CloseUF"
| > UserForm1.Show
| > End Sub
| >
| > Sub CloseUF()
| > Unload UserForm1
| > ''Other stuff
| > End Sub
| >
| >
| > --
| > Jim
| > | > |I have created a splash screen that works fine in Windows Excel but not
on
| > a
| > | MacIntosh. I am using Application.wait to have the splash screen
appear
| > for
| > | five seconds but on the Mac it will not disappear. From my testing it
| > appears
| > | that on the Mac the splash screen is being treated as a modal dialog
box
| > so
| > | the five second timer does not start until after the user has manually
| > closed
| > | it. I have looked at the properites but can't see any place to set it
to
| > | non-modal.
| > |
| > | Any suggestions on how to change this.
| > |
| > | TIA
| > |
| > | Bill
| >
| >
| >

 

[Bill]

Using the vbModeless constant on the Mac generates a parameter violation on
compile. I checked in the VBA Mac documentation and can't find any reference
to the FormShowConstants.

Thanks for the suggestion.

Bill

 

[Mike Middleton]

Bill -

If you don't get assistance here in the microsoft.public.excel.programming
newsgroup, I suggest you try the very acitve
microsoft.public.mac.office.excel newsgroup.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[dan dungan]

Hi Jim,

Where do you put this code to get it to work?

I tried placing both subs in the workbook on open event

The form came up and then an information message:

"The macro "C:\Documents and Settings\My Documents\splashscreen.xls'!
CloseUF' cannot be found."

Dan

 

[Bill]

I try cross-posting it, Thanks

Bill -

If you don't get assistance here in the microsoft.public.excel.programming
newsgroup, I suggest you try the very acitve
microsoft.public.mac.office.excel newsgroup.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[Bob Greenblatt]

I try cross-posting it, Thanks

This ought to work fine. How have you built your splash screen? The best way
is to display a worksheet, and then hide it when the time expires. Let us
know if this does not work, or post a sample of your code.