[Iska]

Попробуйте (не проверялось):

Make sure you reference the addin in your VBA project (Tools - References - Browse).

set a reference to the other workbook/add-in (Tools, References in the VBE)