Change the Fill Effect in an autoshape

Airfix9

Well-known Member
Joined
Sep 23, 2005
Messages
886
Hi all,

Have done some searching and can't find the answer to my question. I use autoshapes to create funky buttons - I usually use the "Bevel" button. To further funkify the buttons, I use different colour effects for each - I particularly like the preset options and have used the Gold, Brass, Silver, Chrome and Sapphire effects a lot.

My question is, is it possible to create further effects similar to these? For example, I would like to create a Ruby effect, like the Sapphire one but in red.

Any help gratefully received - thanks.
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82
I particularly like the preset options and have used the Gold, Brass, Silver, Chrome and Sapphire effects a lot.

My question is, is it possible to create further effects similar to these? For example, I would like to create a Ruby effect, like the Sapphire one but in red.
Instead of Preset, select "Two colors" and experiment with different colors.
 

Airfix9

Well-known Member
Joined
Sep 23, 2005
Messages
886
Hi,

Thanks for the responses (and the heart is excellent, by the way) but I don't think I've made myself too clear.

I am looking for ways to create patterns that are more complex than one colour bleeding into another. For example, the "Rainbow" effect uses multiple colours. I'm looking to do something similar.

Many thanks
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832

ADVERTISEMENT

Seems like you are telling the "heart"macro is OK, but needs more colors...

Can you explain in words what you would like to do exactly?
Also recording a macro doing your actions might help to understand us what you want to do?

I don't know what you mean with all this stuff
I usually use the "Bevel" button. To further funkify the buttons, I use different colour effects for each - I particularly like the preset options and have used the Gold, Brass, Silver, Chrome and Sapphire effects a lot.
what's the Bevel-button :confused:
Gold, Brass, ... :confused:
 

Airfix9

Well-known Member
Joined
Sep 23, 2005
Messages
886
Hi Eric,

Sure, I can explain.

I use the "Drawing" command bar to create 3-D buttons for people to push to get macros to work. If you look at the "Autoshapes" "Basic Shapes", there is one called "Bevel" - it is three across and four down on the palette. Once selected, I draw it on the spreadsheet and then right-click to "Format Auto Shape".

On the "Fill" section, at the bottom of the menu is "Fill Effects". Once I have that, I can colour my button. On the "Gradient" tab, in the top half is a section called "Colors". The bottom option is called "Preset". Select this and you get a combo box of colourways to choose from. "Sapphire" is the last one, the others are above it. The ultimate colourway is "Rainbow".

My question is, how can I recreate Rainbow for my autoshapes?

Hope that clarifies.



As for the Heart - I was just congratulating you on it.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832

ADVERTISEMENT

Very clear explanation, couldn't be less, since I'm not on English Excel.

If you mean you want more colors on your buttons, I think it is not possible using the colors. You can choose the last tab (for me it is "figure") instead of the "Gradient" tab. There you can insert any figure which you can create yourself.

getting closer ?
 

Airfix9

Well-known Member
Joined
Sep 23, 2005
Messages
886
I am beginning to suspect that that is the answer.

Thanks for your help anyway.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
you're WELCOME :)

just noticed your signature
before having all those links in my signature I had
"The more we learn, the more we know that there is still a lot to learn"

well, thanks to you, I learned more about those autoshapes
 

Watch MrExcel Video

Forum statistics

Threads
1,113,788
Messages
5,544,278
Members
410,601
Latest member
Silver2
Top