I figured out I could get around this by adding the reference in the
add-in code instead of manually (though I still don't know why I got
that error). Found this link elsewhere on the help forum:
http://support.microsoft.com/?id=160647
and ran into this error:
http://support.microsoft.com/default...b;en-us;282033
but fixed it as directed.

The problem now is that every time I go to open Excel (with my add-in
installed), I get an alert that tells me that the workbook cannot be
closed because it's being referenced. I believe that the customer will
find this to be very annoying. I also find it annoying. I tried to
shut it off by using the Application.DisplayAlerts = false command, but
I think I must be putting it in the wrong place because it won't
suppress the alert. I put it at the head of the procedure that creates
the reference.

Plus, I don't think that when the alert refers to a workbook being
referenced that it's referring to Book1.xls or whatever I just opened,
because that's not what I referenced. I referenced Solver.


--
Stacy35216
------------------------------------------------------------------------
Stacy35216's Profile: http://www.excelforum.com/member.php...o&userid=15952
View this thread: http://www.excelforum.com/showthread...hreadid=489495