Problem using an Excel 200 Add-in

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top