J
JHJL
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
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