Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
error accessing a protected worksheet | Excel Worksheet Functions | |||
VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |