I had a similar problem that appeared whenever the workbook was
renamed. I resolved this by assigning the macro within Visual Basic as
in the following snippet:


CommandBars("toolbar_name").Controls("Btn_Name").O nAction = _
ThisWorkbook.Name & "!macro_name"