Automatically assigning a macro to a created shape

[vonRobbo]

Hello all,

I have a macro that runs when I click on a shape. This macro is called "Shape_Click"

I can apply that to a shape by selecting it and manually running this macro:

Please Login or Register  to view this content.

What I need help with is how do I get the subroutine to run as soon as the new shape has been selected, rather than haviong to manually run it.


Something like "Sub Worksheet_ShapeAdded" or something like that? I can't work it out.

Thanks in advance.

[LJMetzger]

Duplicate. See http://www.excelforum.com/excel-prog...ml#post3803189

[vonRobbo]

Sorry. My browser crashed as this was posting the first time and it didn't look like it went through.