Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem using an Excel 200 Add-in
Hi - this is my first Excel post so please be gentle!
I have 3 Excel 2000 spreadsheets and they all reference an Add-in. This works fine for most of my users except for 2. These two people are getting compilation errors when they try to load a spreadsheet. The error indicates that although the Add-in is in the VBA Project tree, the declared variables & functions are not visible to the spreadsheets modules. I have tried removing and then re-installing the Add-in on their machine using the spreadsheet menu (Tools-Add-Ins) and also removing and re-installing the reference to the Add-in using the VBA menu (Tools-Refrences) taking care to shutdown and restart Excel after each step. The code within the spreadsheet does not explicitly reference the Add-In variables using "addin.varname" but relies on the "varname" being a public global. Is this a problem? I don't really want have to spell it out as there are 100's of such references to find and fix and it does work for most of my users as is... Any help greatly appreciated regards Julian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |