Jak
Well-known Member
- Joined
- Apr 5, 2002
- Messages
- 833
Hello
I created an Excel Add-in.xla recently and added some code to load a Splash Screen at start up. No problems there. What I would like to do is offer the user a chance to display the splash screen or disable it each time the add-in starts up.
So far...
Once the splashscreen has finished a customised toolbar is added to the MS Toolbar. By selecting the appropriate choice from the custom menu the user can launch frmOptions. This form has CheckBox1 on it. If CheckBox1 is ticked I would like to "retain" the True value and by pass running the splash screen the next time the Add-in is run. This would involve checking frmOptions checkbox1 value. If the value was true then the code would jump past loading "FlashMe" (splash screen form) and run the rest of the code. Else the code would load the FlashMe form at start up. See code below:
Requirement:
I need a way keep checkbox1 value depending on whether it is selected or de-selected so that my start up code can check this value and decide whether or not to load the splash screen. At the moment each time I select it and reload the add-in the checkbox reverts back to a de-selected (false) state. Please also note that this is all part off an add-in and I won't be saving the true or false value to a worksheet.
Any ideas or code would be welcomed.
Jak
I created an Excel Add-in.xla recently and added some code to load a Splash Screen at start up. No problems there. What I would like to do is offer the user a chance to display the splash screen or disable it each time the add-in starts up.
So far...
Once the splashscreen has finished a customised toolbar is added to the MS Toolbar. By selecting the appropriate choice from the custom menu the user can launch frmOptions. This form has CheckBox1 on it. If CheckBox1 is ticked I would like to "retain" the True value and by pass running the splash screen the next time the Add-in is run. This would involve checking frmOptions checkbox1 value. If the value was true then the code would jump past loading "FlashMe" (splash screen form) and run the rest of the code. Else the code would load the FlashMe form at start up. See code below:
Code:
Private Sub Workbook_Open()
If frmOptions.CheckBox1 = True Then GoTo ByPassIntro:
FlashMe.Show 'skip showing the splash screen
ByPassIntro:
'Run rest of code now
Requirement:
I need a way keep checkbox1 value depending on whether it is selected or de-selected so that my start up code can check this value and decide whether or not to load the splash screen. At the moment each time I select it and reload the add-in the checkbox reverts back to a de-selected (false) state. Please also note that this is all part off an add-in and I won't be saving the true or false value to a worksheet.
Any ideas or code would be welcomed.
Jak