Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nat Nat is offline
external usenet poster
 
Posts: 47
Default Compile error when accessing a spreadsheet

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??
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nat Nat is offline
external usenet poster
 
Posts: 47
Default Compile error when accessing a spreadsheet

It seems that if I open the same spreadsheet in 03, enable the macros and go
into VB editortoolsreferences 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!!

"Nat" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with this error-Compile error: cant find project or library JackR Excel Discussion (Misc queries) 2 June 10th 06 09:09 PM
error accessing a protected worksheet Erik Jahre Excel Worksheet Functions 0 February 24th 06 09:32 AM
VBA Error Message "Compile Error...." Steve Excel Discussion (Misc queries) 3 July 15th 05 09:20 AM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 22nd 05 12:39 AM


All times are GMT +1. The time now is 12:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"