@RISK: Shutting Down @RISK from VBA Code

Use Risk.UnloadAddIn after demand-loading Risk via Application.Run("Risk.xla!Risk"); or hide interface with Risk.InterfaceHidden = True.

Title

Answer

Applies to: @RISK for Excel 6.x and Up, Professional and Industrial Editions

Use the Risk.UnloadAddIn method. First, set up the Risk object via demand loading:

Dim Risk As AtRiskOL6.Risk
Set Risk = Application.Run("Risk.xla!Risk")
'... your code ...
Risk.UnloadAddIn

After calling UnloadAddIn, immediately return control to Excel because the unload is asynchronous.

If you prefer not to unload, you can hide the interface instead with Risk.InterfaceHidden = True; set it back to False to show it again.

URL Name

shutting-down-risk-from-vba-code

Related Articles