Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Microsoft Excel 2007/2010, or even Microsoft Office in general,

Say I use the use Insert > Shapes to create a drawing in Excel, is it possible to save this drawing in as a new Shape itself in the Shape dropdown selection? Or maybe under clip art? The Shape needs to be editable and formattable.

In Photoshop, this would be similar to the custom brushes.

It would be better if the new shapes can be associated at the Workbook level rather than Application or Office Suite level.

EDIT: My solution is to create WMF files programatically and save them in a network location. The most important issue addressed here is that the imported drawings can still be edited.

share|improve this question
I would be interested in how you access the WMF files. You attach them to a toolbar in some manner or they were saved as clip art? – datatoo Mar 6 '12 at 14:58
I didn't go to that extent. Just on a network location currently. But it might be more sleek to generate on-the-fly using VSTO excel add-in. Could include a preview pane etc. – Jake Mar 6 '12 at 15:11
great that you found a solution and this is definitely usable information – datatoo Mar 6 '12 at 15:15
up vote 1 down vote accepted

This is not possible in Excel 2007/2010. This article describes what you can and cannot do with shapes in VBA and nowhere is there VBA that will allow us to add a new shape with a new shape index number.

What you can do is copy/paste your shape, or save your shape as a picture and insert it through picture or clipart. You could also put your shape on a template excel file so that it could be used. But, unfortunately, there is no way to add it to the excel shapes index currently.

share|improve this answer
That is such a dissapointment... thanks for the affirmative. I'm going to wait a few more days before marking as answer though. Hope there's tips and advice. – Jake Feb 18 '12 at 8:00
The suggestion that you save your own shape is about all you can do. You could save items like these in a utility sheet but Raystafarian seems to be right here – datatoo Feb 21 '12 at 21:34
@datatoo and Raystafarian In case you are interested, please see my edit – Jake Mar 6 '12 at 8:29
@Jake that is a pretty clever solution – Raystafarian Mar 6 '12 at 11:13

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .