Excel 2003 The macro cannot be found
Posted on 2011-03-01
I create a custom button in an Excel workbook and assign a macro to it. When I copy the workbook to a different folder, open it, and click on the button, the error "The macro <full original path>\my_workbook.xls!my_macro" cannot be found" appears. Why is it looking for the macro in the original location where the workbook was created? How can I fix the problem? I need to distribute this to various locations. Thanks.