How to remove object references from available references list of VBA editor permanently

Question

I added an object reference, which is in DLL, via VBA Editor to my VBA project in Excel. It appeared on the VBA References Dialogue. Now I want to remove it from the list permanently. How can I do it?

Answer 1

Hi,

In order to remove an object reference from the VBA References Dialogue in Excel, you need to follow these steps:

1. Open your VBA project in Excel and go to the VBA Editor.
2. Click on the "Tools" menu and select "References" from the drop-down list.
3. In the References Dialogue box, find the reference you want to remove and uncheck the box next to it.
4. Click on the "OK" button to save your changes and close the References Dialogue box.

If the reference is still listed in the References Dialogue box after unchecking the box, it may be that the DLL file containing the reference is still being used by your Excel. In this case, try closing and reopening Excel to see if the reference has been removed from the list.

Best Regards.