I am not sure why you are getting that error.

I am not sure what is the solution for that, but there is way t
disable and enable addins using macro.


AddIns("Access Links").Installed = False ' will disable Access Link
addin

AddIns("Access Links").Installed = true ' will enable Access Link
addin


so can actually use this code in workbook_open and workbook_close

like in workbook_open you can disable all addins and in workbook_clos
you can enable all disabled addins, so when your workbook is opene
all the addins are disabled and before the workbook is closed all th
disabled addins are enalbed.



this code has to be in "this workbook"

Private Sub Workbook_BeforeClose(Cancel As Boolean)
AddIns("Access Links").Installed = true' will disable Access Link
addin
'and more
End Sub

Private Sub Workbook_Open()
AddIns("Access Links").Installed = False ' will disable Access Link
addin
'and more

End Su

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=38327