Running a macro when a shape is created

  • Hi all,

    This is the first time I have actually had to post a question here rather than finding the answer via a search, so I hope what I am trying to do is feasible without too much effort!

    I have a worksheet which I've created that takes a visual representation of a workflow created with shapes and connectors, and converts it into a series of worksheets.

    It works well, and each created sheet is named after the caption of each non-connector shape.

    What I would like to do is execute a macro whenever a shape is created that prompts the user to type in a caption (thinking via a simple inputbox) but I can't find a suitable event to hook.

    I am not tied to using the shape caption property, although it seems to make sense.

    Any suggestions please?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!