Hello,

on my computer I work with EXCEL 2003. The installed operating system is
Windows XP Pro. Now I have a question concerning the IDE.

When I start the editor for visual basic appliction then I get access to a
dialog box that enables me to add objects (DLL, TLB .... ) to EXCEL. My
EXCEL is in German, but in English the name of the menu should be =tools
=references ... Within the appearing dialog box I can check available
references and add external references to the list of references.

It is very easy to add a new reference. However, how do I delete a
reference?

I appreciate any help and would like to say thank you in advance!

Best regards,
Christian Lehmann

Christian,

You cannot delete a reference, all you can do is to uncheck it and make it
not available to the project. It doesn't create any overhead, all that will
remain is that Excel knows where that library is stored should you restate
it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Christian Lehmann" wrote in message
...
Hello,

on my computer I work with EXCEL 2003. The installed operating system is
Windows XP Pro. Now I have a question concerning the IDE.

When I start the editor for visual basic appliction then I get access to a
dialog box that enables me to add objects (DLL, TLB .... ) to EXCEL. My
EXCEL is in German, but in English the name of the menu should be =tools
=references ... Within the appearing dialog box I can check available
references and add external references to the list of references.

It is very easy to add a new reference. However, how do I delete a
reference?

I appreciate any help and would like to say thank you in advance!

Best regards,
Christian Lehmann

Thank you for your respoonse! But how can I solve the following problem:
the path to the object (in this case a TLB-file) has changed (it was a
network path). So if I still want to use all makros that need this TLB-file
I have to update the reference. Is there any other way to do this but
setting up my computer again?

Thank you for any help!

Christian