How to create transparent objects on images in Excel

[Simon Lenn]

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 here:

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

 

[Rocky McKinley]

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.