I think you have to make a different version of your workbook, one with the
references removed and all code calling referenced routines removed or
commented out or put inside conditional compilation directives.

--
Jim
"Mike Jerakis" <Mike wrote in message
...
|I have a file that on my machine I need it to do things in VBA with other
| add-ins. To use those add-ins in Excel, you must create a reference to
the
| .XLA and then there is VBA code to take advantage of the add-in.
|
| I would like to send this file as a whole to do someone else and not have
| library reference errors. There is VBA code with references to this
library
| spread throughout the various modules. So when a user without this one
| library tries to open the file, the VB tries to compile and cannot
correctly
| do so and therefore renders all the VBA code useless.
|
| Is there a way to get the file to open with regard to these library
| problems? And let the rest of the VBA needs get used?