I have a number of workbooks that are distributed across my company
that use functions found in the Analysis Tool Pak. I'm learning that
some people don't have that add-in checked so they receive an update
links error/message when they open the file. I placed the following
code in the Woerksheet.Open" event. Unfortunately, it appears to run
after the sheet attempts to update links. How can I avoid the update
links message?

Thanks - John

Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True
End Sub