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

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
"Bill" <(E-Mail Removed)> wrote in message
news:C4E5BCAA-BC00-4422-A566-(E-Mail Removed)...
|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

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
> "Bill" <(E-Mail Removed)> wrote in message
> news:C4E5BCAA-BC00-4422-A566-(E-Mail Removed)...
> |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
>
>
>

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
"Bill" <(E-Mail Removed)> wrote in message
news:ED3E1B9F-930D-4E5F-AC75-(E-Mail Removed)...
| 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
| > "Bill" <(E-Mail Removed)> wrote in message
| > news:C4E5BCAA-BC00-4422-A566-(E-Mail Removed)...
| > |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
| >
| >
| >

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

"Jim Rech" wrote:

> 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
> "Bill" <(E-Mail Removed)> wrote in message
> news:ED3E1B9F-930D-4E5F-AC75-(E-Mail Removed)...
> | 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
> | > "Bill" <(E-Mail Removed)> wrote in message
> | > news:C4E5BCAA-BC00-4422-A566-(E-Mail Removed)...
> | > |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 -

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" <(E-Mail Removed)> wrote in message
news:C4E5BCAA-BC00-4422-A566-(E-Mail Removed)...
>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

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

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" <(E-Mail Removed)> wrote in message
> news:C4E5BCAA-BC00-4422-A566-(E-Mail Removed)...
> >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
>
>
>

On 4/16/08 2:21 PM, in article
5F12777E-02A4-47A6-9954-(E-Mail Removed), "Bill"
<(E-Mail Removed)> 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" <(E-Mail Removed)> wrote in message
>> news:C4E5BCAA-BC00-4422-A566-(E-Mail Removed)...
>>> 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