Just to follow up, I've been thinking about doing this for a while, but the thought of opening hundreds of workbooks, copying the macros to a Personal.xlsb and then sorting through and deleting duplicates is a daunting task. Has anyone ever automated this process?