Startup Scripts

Ideally, users shouldn’t need to manually start Crystal Ball. You can use scripting to make sure that Crystal Ball automatically loads with Microsoft Excel, or you can start the Crystal Ball launcher file (CBLauncher.exe), installed with Crystal Ball, to make sure Crystal Ballstarts, as follows:

To ensure that Crystal Ballstarts automatically when Microsoft Excel starts, set the following registry key to a value of 3:
```
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\SecureCBAddin.Connect\LoadBehavior
```
This is the same as checking the checkbox to automatically launch Crystal Ballwhen Microsoft Excel starts in the Crystal BallApplication Manager.
Note:
Be sure to set the registry key value back to 2 when the application closes.
OR,
To confirm that Crystal Ballis running before you run any Crystal BallDeveloper Kit code in the custom application, call CBLauncher.exe as follows:
```
C:\Program Files\Oracle\Crystal Ball\Bin\CBLauncher.exe
```
where the installation folder part of this call should be modified if CB is installed on a non-English machine or to a non-default installation folder.
OR,
You can use new Crystal Ball Developer Kit calls to open and close Crystal Ball and determine load status: CB.CBLoaded, CB.GetCBAutoLoad, CB.SetCBAutoLoad, CB.Shutdown, and CB.Startup. For more information about these calls, see Crystal Ball Macro Calls.