You could try to use a dynamic Picture link.
Is a bit complicated to explain in detail, so I'll try with an example.

1. Insert a red Circle (autoshape) and add a text R and place it over cell D1.
2. Then add the Icon-button 'Camera'. It located under the Tools menu category.
3. Mark the cell where your button is located (D1)
4. Now Click the camera and paste where your R should be (this is now a active picture link).
5. Next create a Green button and place it over E1.
6. Click on your picture link. The formula bar will show the cell reference =$D$1.
7. Insert a Define Name called Button. and use the formula =IF(A1=1,D1,E1). This will focus the picture link on either the Red or the Green button.

This is the principle.

Ola Sandstrom