VBAProject references
 

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

VBAProject references
 

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

--
Regards,
Tom Ogilvy


"Bob Spurbrand" <Bob wrote in message
...
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

VBAProject references
 

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" wrote:

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

--
Regards,
Tom Ogilvy


"Bob Spurbrand" <Bob wrote in message
...
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

VBAProject references
 

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.

--
Regards,
Tom Ogilvy

"Bob Spurbrand" wrote in message
...
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" wrote:

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

--
Regards,
Tom Ogilvy


"Bob Spurbrand" <Bob wrote in
message
...
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