View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.mac.office.excel
Bob Greenblatt Bob Greenblatt is offline
external usenet poster
 
Posts: 4
Default Creating Splash Screen in Excel 2004 MacIntosh

On 4/16/08 2:21 PM, in article
, "Bill"
wrote:

I try cross-posting it, Thanks

"Mike Middleton" wrote:

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



"Bill" wrote in message
...
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




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.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom