I have a worksheet that displays the performance for a single retail
outlet. I change the location name and via lookups I change the data
in the worksheet to reflect the sale performance for the new location.

I would like to have a unique photo of each retail location when I
select a different location.

Is there any way to programmatically have a new photo automatically
display when a new location is selected?

Steve Sammons