Use this idea to assign to a worksheet_change event and use if to toggle.

ActiveSheet.Shapes("picture 1").Visible = True


--
Don Guillett
SalesAid Software

"Big D" <Big wrote in message
...
Does Excel allow you to assign a value to a picture and vice versa?

I want to create a database that can create a visual report. The database
would be a table with specific percentages. However, when I need to
generate
a report, those percentages need to be translated into pictures.

An example: A worker completes one task and not the other. The database
records a 1 to show the task is completed or 0 to show the task has not
been
completed. When I need to print the worker's evaluation report, I want
the
printout to show a happy face if the task was completed and an unhappy
face
if it wasn't completed.

Suggestions?

Much appreciated!