Pretty Buttons...

Hi all,

So I've got a number of buttons on a spreadsheet with macros assigned to them. No problem there. I'm wondering if anyone knows if I can do anything to make them look a bit more interesting than the grey blocks that they currently are. Can't seem to find any kind of formatting options that deals with the appearance.

I know I can use the the Custom Buttons feature, but this is a corporate document and I'm not sure the CEO would approve of big smiley face buttons, a la early 90s rave T-shirts. I'm thinking more in terms of colour, perhaps a gradient - that type of thing.

TIA,

SamuelT

Samuel

"Buttons with macros assigned to them" are usually those from the Forms
toolbar. You can't change them much. But you can assign those macros to
absolutely everything created by the Drawing toolbar; pictures, textboxes,
shapes, ... You can make it look like whatever, and the result depends only
on your style and taste.


HTH. Best wishes Harald

"SamuelT" <[email protected]> skrev i
melding news:[email protected]...
>
> Hi all,
>
> So I've got a number of buttons on a spreadsheet with macros assigned
> to them. No problem there. I'm wondering if anyone knows if I can do
> anything to make them look a bit more interesting than the grey blocks
> that they currently are. Can't seem to find any kind of formatting
> options that deals with the appearance.
>
> I know I can use the the Custom Buttons feature, but this is a
> corporate document and I'm not sure the CEO would approve of big smiley
> face buttons, a la early 90s rave T-shirts. I'm thinking more in terms
> of colour, perhaps a gradient - that type of thing.
>
> TIA,
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=545503
>

Thanks guys. I'll open up Photoshop and get snazzy!

use shapes from the drawing toolbar that can be customized in many ways with
a macro assigned to them.

--
Don Guillett
SalesAid Software
[email protected]
"SamuelT" <[email protected]> wrote in
message news:[email protected]...
>
> Hi all,
>
> So I've got a number of buttons on a spreadsheet with macros assigned
> to them. No problem there. I'm wondering if anyone knows if I can do
> anything to make them look a bit more interesting than the grey blocks
> that they currently are. Can't seem to find any kind of formatting
> options that deals with the appearance.
>
> I know I can use the the Custom Buttons feature, but this is a
> corporate document and I'm not sure the CEO would approve of big smiley
> face buttons, a la early 90s rave T-shirts. I'm thinking more in terms
> of colour, perhaps a gradient - that type of thing.
>
> TIA,
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile:
> http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=545503
>

I use imported images, .jpg's etc, and assign the macros to them.
I have one for each member of my family, my pets, etc etc..........

hth
Vaya con Dios,
Chuck, CABGx3




"SamuelT" wrote:

>
> Hi all,
>
> So I've got a number of buttons on a spreadsheet with macros assigned
> to them. No problem there. I'm wondering if anyone knows if I can do
> anything to make them look a bit more interesting than the grey blocks
> that they currently are. Can't seem to find any kind of formatting
> options that deals with the appearance.
>
> I know I can use the the Custom Buttons feature, but this is a
> corporate document and I'm not sure the CEO would approve of big smiley
> face buttons, a la early 90s rave T-shirts. I'm thinking more in terms
> of colour, perhaps a gradient - that type of thing.
>
> TIA,
>
> SamuelT
>
>
> --
> SamuelT
> ------------------------------------------------------------------------
> SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
> View this thread: http://www.excelforum.com/showthread...hreadid=545503
>
>