Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Splash Screen in Excel 2004 MacIntosh
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Splash Screen in Excel 2004 MacIntosh
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" 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Splash Screen in Excel 2004 MacIntosh
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" 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Splash Screen in Excel 2004 MacIntosh
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" wrote in message ... | 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" 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 | | | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Splash Screen in Excel 2004 MacIntosh
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" wrote in message ... | 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" 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 | | | |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Splash Screen in Excel 2004 MacIntosh
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Splash Screen in Excel 2004 MacIntosh
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 |
#8
Posted to microsoft.public.excel.programming,microsoft.public.mac.office.excel
|
|||
|
|||
Creating Splash Screen in Excel 2004 MacIntosh
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Splash Screen | Excel Programming | |||
Create a splash screen in excel | Excel Programming | |||
Save Excel 2002 to be read by MacIntosh Excel 2004? | New Users to Excel | |||
Send Excel 2002 spreadsheet to MacIntosh Excel 2004 | Excel Discussion (Misc queries) | |||
Splash screen on opening excel | Excel Programming |