VBA Project "Reference To" another (protected) project

MisterT · Mar 2nd 2005

Hi,

My personal.xls file has a reference to a protected add-in showing in the VBE which causes an error on opening excel.
Any ideas how can I remove the reference?

On a similar note: Does anyone have the saved link for that great "Code Cleaner" macro I remember using a while back?

Thanks in advance,

Mike

Anonymous · Mar 2nd 2005

Re: VBA Project "Reference To" another (protected) project

You are probably referring to Rob Bovey's Code Cleaner. One link that has it is http://www.bmsltd.ie/MVP/MVPPage.asp

As to removing the reference, when in the VBE with your personal.xls file active, just go to the Tools>References menu and uncheck the reference.

MisterT · Mar 3rd 2005

Re: VBA Project "Reference To" another (protected) project

That's great Derk. Thanks.

Rob Bopvey's Code Cleaner is exactly what I'm after. Does anybody have a zipped copy or a link to a zipped copy as the firewall blocks .exe files?

Thanks in advance,

Mike

VBA Project "Reference To" another (protected) project

Participate now!

Share