Compile error when accessing a spreadsheet

[Nat]

We have an external workbook in 97-03 mode, which when we save & open brings
up a spreadsheet, labeled NoMacros, which says "if you are reading this, you
don't have macros enabled.." from here, you can choose Security Warning
Options>Enable this content, however this just brings up a MS VB dialog box
which states "COMPILE ERROR .. Can't find project or library. It references
the following code:

Private Sub Workbook_Open()

'Check for the "Analysis Toolpak - VBA" Addin and let them know if it needs
to be installed
gErrorName = "Deny Installation"
If AddIns("Analysis Toolpak").Installed = False Then
Add_Ins = MsgBox("The Addin ""Analysis Toolpak"" needs to be
installed." & vbCrLf & vbCrLf & _
"It will only take a moment.", vbOKCancel)

I have added teh following add-ins: Analysis ToolPak", "Analysis ToolPak -
VBA", and "Conditional Sum Wizard". but nothing works.

When I try this in Excel 03, you just set the macro levels to low or medium,
and it never even shows the 1st tab (NoMacros). How do I resolve this issue
in Excel 07??

 

[Nat]

It seems that if I open the same spreadsheet in 03, enable the macros and go
into VB editor>tools>references and Clear the check box for the type library
or object library marked as "Missing:" and save the workbook I can resolve
this issue. Is there just a setting I can select in 07, that will allow me
to avoid this step in the future? I have played with all the macro and trust
center settings but the only thing that seems to work is to open & save in
Office 03. Help!!