you can set a reference to an add-in project from a macro workbook then use the code (mostly) as if it were in the macro workbook. the only thing saved with the workbook is the reference