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 |
All times are GMT +1. The time now is 05:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com