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
OptionsEnable 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??