Hi -

I've created a "patch" tool to update a complex workbook used by approx 50 people. Among many other things, the patch updates several macros (using Chip Pearson's fabulous "Copy A Module" code, http://www.cpearson.com/excel/vbe.aspx) and then re-attached macros using the .OnAction command. There are 6 modules updated and close to 250 macros re-attached.

The problem is, on 2 of the re-attaches ... the assigned-macro ends up being linked to the patch file and not the macro within the tool. For example:

the assigned macro should be: UpdateSalesHours
but instead shows as: 'Patch 02-083116_NEW.xlsm'!UpdateSalesHours

None of the other 200+ re-attaches does this ... why does this one?

I've tried replacing the modules in different orders, doing the re-attaches in different orders ... no change.

Any idea what would cause this? and more importantly, how to fix it?

Thanks in advance,
Ray