I have a SplashScreen that is activated in the ‘Workbook_Open ‘ Event.
A CheckboxControl on the SplashScreen allows a user to disregard the screen the next time the workbook is opened.
<o> </o>
Unfortunatley my code is not working. I was hoping for some insight into making this work. Mind you, I’m a cut and paste VBA type of person, but I do understand the concepts enough to work with it.
<o> </o>
<!--[if !supportLists]-->1.<!--[endif]-->What is the proper method for coding this?
<!--[if !supportLists]-->2.<!--[endif]-->Which location would this code be placed – the Form itself or a Module?
<!--[if !supportLists]-->3.<!--[endif]-->How and where do you store the CheckBox Value to be used the next time the Workbook is opened?
<o> </o>
Much appreciated.
A CheckboxControl on the SplashScreen allows a user to disregard the screen the next time the workbook is opened.
<o> </o>
Code:
Private Sub Splash_Screen_Activate()
<o:p> </o:p>
If Splash_Screen.ckbx_StopSplashScreen.Value = True Then
Splash_Screen.Hide
Else<o:p></o:p>
<o:p> </o:p>
If Splash_Screen.ckbx_StopSplashScreen = False Then
Splash_Screen.Show
End If
End If
<o:p> </o:p>
End Sub
<o> </o>
<!--[if !supportLists]-->1.<!--[endif]-->What is the proper method for coding this?
<!--[if !supportLists]-->2.<!--[endif]-->Which location would this code be placed – the Form itself or a Module?
<!--[if !supportLists]-->3.<!--[endif]-->How and where do you store the CheckBox Value to be used the next time the Workbook is opened?
<o> </o>
Much appreciated.