Macro names in a Module
I've found that assigning a macro to a toolbar control employs the
filename as a prefix to the macro name. EX: myfile.xls!macro1. If the
workbook is renamed or a copy made with a different name, the controls
will continue to look for the macro in the original file. Is there any
way to limit the assigned name to the macro name only?
|