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?