Hi folks, If I could open this up to include assigning macro's to custom
buttons in custom toolboxes, which is virtually the same process as assigning
a macro to an autoshape, I find the problem is, when I assign a macro and the
Assign macro window pops up, there is an option to select "This Workbook".
When you select a macro it appears without a path but as soon as you close
the window and open it again, the macro is appened with a path, and the path
includes the name of the excel file. If I rename the excel file then the
path is no longer valid and "marcro not found" results. Is it possible to
provide only the macro name within the workbook, no path data, so it only
looks inside the workbook regardless of it's current file name?