How to create transparent objects on images in Excel

Hello All

John Walkenback said in one of is articles on clickable images is to
place a image and place transparent objects on the image and write
event handlers for the transparent objects to create clickable images.

Please find John Walkenbach's article on this topic he

http://www.j-walk.com/ss/excel/tips/tip41.htm

NOTE: Another way to create an image map is to insert transparent
objects over the image, and create event-handler subroutines for the
objects.

I have a country map and want to insert transparent objects and write
event handlers for them I have created buttons and I cannot set them
transparent can of you please share your thoughts on how I can create
transparent objects.

Many thanks
Simon

Use the drawing toolbar and insert an "AutoShape" object on the map.
Right Click on the autoshape and select "Format AutoShape".
Select the Colors & Lines tab at the top
Set the "Color Transparency" to 100%
Set the "Line/Color" to no line.

RightClick again to assign a macro to the object.

--
Regards,
Rocky McKinley


"Simon Lenn" wrote in message
om...
Hello All

John Walkenback said in one of is articles on clickable images is to
place a image and place transparent objects on the image and write
event handlers for the transparent objects to create clickable images.

Please find John Walkenbach's article on this topic he

http://www.j-walk.com/ss/excel/tips/tip41.htm

NOTE: Another way to create an image map is to insert transparent
objects over the image, and create event-handler subroutines for the
objects.

I have a country map and want to insert transparent objects and write
event handlers for them I have created buttons and I cannot set them
transparent can of you please share your thoughts on how I can create
transparent objects.

Many thanks
Simon