Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 3 seperate workbooks that I have generated. 1 is a hexagonal map with
letter-number designations for each cell. I created a lot of hex auto shapes then exactly lined them up and grouped them as 1 object on the first workbook. The 2nd is small font text which represents a label for the contents of a cell. The 3rd is a very large font arrow pointing to 1 of the 6 sides. The different size font was the reason I had to use this embed object method (or the only feature in excel I could find that seemed to do what I needed) I am using InsertObject "Create from file" with "Link to file" checked and pulling each of these 3 workbooks into a new workbook. Then I use the right-click to "format object" then in the "colors and lines" tab I set the transparency to 100% on all 3 objects (scrolling through them with "send to back")... 2 of them seem to merge... but 1 of them, even though set to 100% transparent, will remain opaque. I have seen this work with 3 objects before (I can make 3 simple new files to test this and it does work), but now I cant figure out why, in my "real" files, 1 remains opaque. It is the one with the arrows that seems to stay opaque. I am using these "†‘†—†˜†“†™†–" Arial Unicode MS in font size 36 or so in 100x100 pixel cells. Anyone have any ideas what I can do to fix this problem? It seems to happen both on Excel2003 and 2000. -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to make a cell filled w/color more transparent? | Excel Discussion (Misc queries) | |||
how to make transparent background | New Users to Excel | |||
How to make inserted picture transparent so the cells will show? | Excel Discussion (Misc queries) | |||
Camera Object - how to set default Fill = Transparent | Excel Discussion (Misc queries) | |||
How do I make Macro Buttons Transparent ? | Excel Programming |