I have a button assigned to a macro that I moved to an add on. To reassign
it in the macro name dropdown I type 'My vba code.xla'!MyFunctionName.
But when I click on the button it says Macro MyFunctionName not found.
When I go back into to edit the macro name it has stripped away the xla
reference and just left the macro name which suggests it has found it.
Anyone know what the problem might be?

Regards, Tom.