<div>
Sid,<br />
<br />
Greetings again! &nbsp;Here's what I'm using to load it from &quot;This Workbook&quot;<br />
<br />
Option Explicit<br />
Private Sub Workbook_Open()<br />
&nbsp; &nbsp; Sheets(&quot;Splash&quot;).Select<br />
&nbsp; &nbsp; Application.OnTime Now() + TimeSerial(0, 0, 1), &quot;module1.ShowForm&quot;<br />
&nbsp; &nbsp; Worksheets(&quot;timer&quot;).RunChe<wbr />ck<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; End Sub<br />
&nbsp; &nbsp; <br />
'This code opens the splash screen
</div>


Sid,

Greetings again!  Here's what I'm using to load it from "This Workbook"

Option Explicit
Private Sub Workbook_Open()
    Sheets("Splash").Select
    Application.OnTime Now() + TimeSerial(0, 0, 1), "module1.ShowForm"
    Worksheets("timer").RunCheck
   
    End Sub
   
'This code opens the splash screen

<div>
Show Modal is &quot;True&quot; under properties. 
</div>


<div>
Simple solution - Effective solution. &nbsp;Sid, Thanks Much for your help. &nbsp;Sorry it took me so long to test it.<br />
<br />
Best regards,<br />
<br />
B.
</div>


Simple solution - Effective solution.  Sid, Thanks Much for your help.  Sorry it took me so long to test it.

Best regards,

B.

<div>
<div class="content wysiwyg-content">
I have a Splashscreen that when I open my spreadsheet, it automatically comes up. &nbsp;It has a set of conditions that the user must adhere to and a button that says &quot;Accept&quot;. &nbsp;The problem I have is that there is no ability to halt access. &nbsp;In other words, the user can simply move on to the next screen. &nbsp;What needs to happen is that until the button is pressed, access to the rest of the spreadsheet should be disabled. <br />
<br />
Thank you.<br />
<br />
B.
</div>
</div>


I have a Splashscreen that when I open my spreadsheet, it automatically comes up.  It has a set of conditions that the user must adhere to and a button that says "Accept".  The problem I have is that there is no ability to halt access.  In other words, the user can simply move on to the next screen.  What needs to happen is that until the button is pressed, access to the rest of the spreadsheet should be disabled. 

Thank you.

B.

Conditional Stop on Splashscreen with Form

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.