Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create custom AutoShapes?
Anyone know if it's possible to create custom AutoShapes? The key
differential factor between AutoShapes and other pictures, clipart, etc. being that AutoShapes allow you to add text. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create custom AutoShapes?
AFAIK not possible to create a custom Autoshape (assuming you don't mean a
Freeform). However you could assign a picture to say a rectangle, then add text. Format Fill Fill effects Picture Regards, Peter T "Nick Hebb" wrote in message ups.com... Anyone know if it's possible to create custom AutoShapes? The key differential factor between AutoShapes and other pictures, clipart, etc. being that AutoShapes allow you to add text. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create custom AutoShapes?
Not a bad idea. The text framing isn't perfect, but it just might work.
Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create custom AutoShapes?
I can understand the picture framing not being quite right but, out of
curiosity, what do you mean by "text framing isn't perfect". Not sure why it would be any different to a normal autoshape, at least as far as the text is concerned. Regards, Peter T "Nick Hebb" wrote in message oups.com... Not a bad idea. The text framing isn't perfect, but it just might work. Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create custom AutoShapes?
By text framing, I mean the text frame within the AutoShape. Let's say
you're using a Flowchart Decision AutoShape (i.e. a diamond). The textframe is the largest rectangle that will fit inside the shape, so for the diamond, the text frame is much smaller than the shape itself. Since picture are rectangles, I would need to to use a rectangle (or Flowchart Process) AutoShape to contain the picture. Since the default textframe for the rectangle AutoShape probably won't match the area that I want to add text to, I would need to play with the internal margins. It's not perfect, but it may work. I'll need to play around with it some more. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create custom AutoShapes?
Nick,
What shape are you after that is not available as an AutoShape ? NickHK "Nick Hebb" wrote in message ups.com... By text framing, I mean the text frame within the AutoShape. Let's say you're using a Flowchart Decision AutoShape (i.e. a diamond). The textframe is the largest rectangle that will fit inside the shape, so for the diamond, the text frame is much smaller than the shape itself. Since picture are rectangles, I would need to to use a rectangle (or Flowchart Process) AutoShape to contain the picture. Since the default textframe for the rectangle AutoShape probably won't match the area that I want to add text to, I would need to play with the internal margins. It's not perfect, but it may work. I'll need to play around with it some more. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to create custom AutoShapes?
Yes I see what you mean. In addition to playing with margins maybe center
aligning text both horizontally & vertically might assist. Have you considered placing a textbox over your picture and grouping. Format the textbox with invisible Fill and border. Regards, Peter T "Nick Hebb" wrote in message ups.com... By text framing, I mean the text frame within the AutoShape. Let's say you're using a Flowchart Decision AutoShape (i.e. a diamond). The textframe is the largest rectangle that will fit inside the shape, so for the diamond, the text frame is much smaller than the shape itself. Since picture are rectangles, I would need to to use a rectangle (or Flowchart Process) AutoShape to contain the picture. Since the default textframe for the rectangle AutoShape probably won't match the area that I want to add text to, I would need to play with the internal margins. It's not perfect, but it may work. I'll need to play around with it some more. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to create your own custom format? | Excel Discussion (Misc queries) | |||
How do I create my own custom button? | Excel Discussion (Misc queries) | |||
Excell 2003-How Do I get custom drawn shapes into Autoshapes file | Excel Programming | |||
How do I create a custom add-in | Excel Programming | |||
create custom filter | Excel Programming |