Hi,
I tried several ways as suggested on line to assign a shape to a macro. This can be done interactively, however; there are several hundred assignments to be made over several sheets.
It would be super if I could nail the syntax to just assign one.
Recording this action shows: selection.onaction = "Sheet26.rm221m" ' and that's all.
Several attempts to code this give error message: run time error 438 object doesn't support this property or method
A sub on the active sheet26 containing shape rm221 and macro rm221m
Sheet26.Shapes("rm221").selection.onaction = "Sheet26.rm221m"
Several alterations to the line above were tried, including adding the workbook in the assignment.

How can I assign a macro to a shape in VBA 2007
Thanks,
Keith