Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 391
Default How remove invalid references in ToolsReferences drop down box?


2003, 2007 up to date

In VBE editor I have line-items in the drop down box Available References: that are missing.

I do not mean invalid or missing Checked items but invalid line items in the dropdown box.

i.e. There is a item listed as CT - Math.

If I select it, then OK; I get "Error in loading DLL" That is true because it was deleted.

How can I delete that and other like items.

TIA EagleOne
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default How remove invalid references in ToolsReferences drop down box?


Sounds like you deleted the dll without uninstalling (un-registering it). If
possible reinstall it with the original installer and use same to uninstall
it. If that's not available, depending on what type of dll it is, you might
be able to manually register it with Regserv32 and unregister it with the /u
switch (assuming you have the original file to hand, eg in the recycle bin).

Failing that look into a third party registry cleaner (others might be able
to recommend one).

Regards,
Peter T


wrote in message
...
2003, 2007 up to date

In VBE editor I have line-items in the drop down box Available References:
that are missing.

I do not mean invalid or missing Checked items but invalid line items in
the dropdown box.

i.e. There is a item listed as CT - Math.

If I select it, then OK; I get "Error in loading DLL" That is true
because it was deleted.

How can I delete that and other like items.

TIA EagleOne



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
References in VBA (Tools - References) Alan Excel Programming 3 November 28th 05 11:44 PM
Tools...References shows "MISSING:" in front of 2 references Mike Jamesson Excel Programming 1 October 19th 05 06:33 PM
Remove "Missing" reference in VB-Tools-References Alan Excel Programming 1 December 21st 04 04:37 AM
Tools | References - information about references L Mehl Excel Programming 6 July 4th 04 06:28 PM
References.Remove References(1) DOES NOT WORK for "MISSING:" Refs Jamie Carper[_2_] Excel Programming 0 May 27th 04 04:22 PM


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"