VBAProject references

[Guest]

After adding a reference (An excel addin) to my project I find that I can't
remove it from the list of available references.

Although the addin has been deleted excel still looks for it when any
workbook is open.

Can anyone tell me where the list of references is held and how to remove one.

Thanks

 

[Tom Ogilvy]

It is stored in the workbook. Try removing it with code.

 

[Guest]

I can remove the tick on the reference dialog by code but I don't know how to
remove it completely so it is no longer availailable to be selected.

Thanks Bob

 

[Tom Ogilvy]

Try unchecking it in Tools=>Addins in Excel. Then check it again - and
Excel should offer to remove it from the list since the file can't be found.

Perhaps that will solve the problem.