Rob
I saved the image as gif with the option "alphatransparent" (with Macromedia
Fireworks) and stored it in the Excel worksheet. When I try to set the
background color of the picture in Excel to "transparent" (as you
described), the picture becomes complety transparent, then I displayed this
"completely transparent picture" as coomandbar symbol, but the background of
the commandbar symbol is white and not transparent?!?
Tom
"Rob Bovey" schrieb im Newsbeitrag
...
Hi Tom,
Have you set the background color as transparent using Excel 2003 and
saved it there? That's the only way to have any image appear properly in
Excel 2003. It uses a different underlying drawing method for its graphics
than previous versions, so if you set the image to transparent in any
previous version it will not appear transparent in Excel 2003.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
"Tom" wrote in message
...
Rob
Thank you for your answer. The background color is already set to
transparent. The picture will be displayed correctly with Excel 97, 2000
&
2002, but with Excel 2003 it is displayed very ugly.
Tom
"Rob Bovey" schrieb im Newsbeitrag
...
Hi Tom,
The Picture toolbar has a special control that is designed to make
any
background color you click transparent. First select your picture with
your
mouse. Then, display the Picture toolbar, by right-clicking over the
toolbar area and selecting the Picture toolbar from the shortcut menu.
On
this toolbar, the second button from the right button is called Set
Transparent Color.
Click this button and your cursor will turn into a
downward-pointing
arrow just like the picture on the toolbar button. Place the tip of
the
downward-pointing arrow on the color of your image that you want to
make
transparent and then click. That's all you need to do, the color you
clicked
on will become transparent.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
"Tom" wrote in message
...
Hi
I created a customized toolbar with my own symbols, but with Excel
2003
the
symbols are displayed very ugly. I'm using the following script to
display
the symbols:
Sub Example()
Dim cbrCtrl As CommandBarControl
ThisWorkbook.Worksheets(1).Shapes(1).Copy
Set cbrCtrl = Application.CommandBars("Tools").Controls.Add
With cbrCtrl
.Caption = "Hello World"
.OnAction = ThisWorkbook.Name & "!blabla"
.PasteFace
End With
Application.CutCopyMode = False
End Sub
The problem is, that the symbols won't be converted to a transparent
picture. Well, I found the following articles, which describes the
solution,
but these examples are too difficult for me:
http://support.microsoft.com/default...71&Product=ofw
HOWTO: Create a Transparent Picture For Office CommandBar Buttons
http://support.microsoft.com/default...17&Product=ofw
HOW TO: Set the Mask Property and the Picture Property for an Office
2003
CommandBar Button
What I need is an example to create a transparent picture. The
picture
is
stored is within the workbbok (not a file). I'm willing to pay for
it!!!
If
there is anybody out there who can help me please contact me.
Tom