Assume macro code is saved in "This Workbook" of old.xls and assigned to a button on "MyToolbar" which is attached to old.xls. I now want to give a copy of this file to someone so I open it, then SaveAs new.xls. At this point new.xls contains (a copy of) the code in "This Workbook". If I attach MyToolbar to new.xls, the macro from the toolbar button still references old.xls.
How can I truly create a copy of the file, complete with all code from "This Workbook" and all sheets, including its own attached copy of MyToolbar with button referencing macro code in the new file?
How can I truly create a copy of the file, complete with all code from "This Workbook" and all sheets, including its own attached copy of MyToolbar with button referencing macro code in the new file?