thanks Tom, re the calculation: I appreciate what you are saying, but can I
alter calculation to manual ONCE the workbook is opened? This might be OK if
I can - I guess that I wasn't precise enough in my question

Bill

"Tom Ogilvy" wrote:

Calculation is an application level setting and it is utilized before your
code would run, so you can't control that for the opening of your workbook.

Sub AddinInstall()
With Application.AddIns("Analysis Toolpak - VBA")
If .Installed = False Then
.Installed = True
End If
End With
With Application.AddIns("Analysis Toolpak")
If .Installed = False Then
.Installed = True
End If
End With
End Sub


--
Regards,
Tom Ogilvy



"Bill Hall" wrote in message
...
When my Excel workbook is opened, I want the Excel code to check to see if
the Add-Ins "Analysis Toolpack" is already installed on the user's Excel
application. Because I am using several of the Analysis Toolpack
functions
in my worksbook, I need the Add-Inns to be installed. If it isn't
installed,
how do I code Excel to automatically install the "Add-Ins" when the
workbook
is opened?

Similary, I need the Tools Options Calculation to be on MANUAL for the
workbook to function normally. Am I able to include that in my code?

Thanks in anticipation

Bill Hall