One user opened Excel Tools > Add-Ins and checked the two addins, and still
got a failure (Can't find project or library) when launching the .xls file I
sent.
Would the following work for users of a forms project I send for general use
(they have various versions of Office, which includes Excel):
Public Sub Auto_Open()
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
frmCorrectiveAction.Show
End Sub
Or is it also necessary for them to do something explicitly in VBA? (i.e.,
set up the Project Reference)...