I developed a function that works perfectly when it is inside my workbook in a BVA module. I just put the function in one protected workbook and saved it as an Excel Add-in. I made the add-in available (checked it!) to all workbooks in the 2007 Excel menu. However, If I want to use a different workbook with the formula, it states "#name"?. Anyone out there knows what may be the problem? Thanks!