I have this code that will automatically load the ATP. but if the user did not initially install it on their computer when they installed their excel program, can anyone help rewrite the code to check to see if it is installed and if not , create a msgbox indicating not installed.
Code:
Private Sub Workbook_Open()
If AddIns("Analysis ToolPak").Installed Then
MsgBox "already installed"
'No action required since add-in already loaded
Else
AddIns("Analysis ToolPak").Installed = True
End If
End Sub