Hi All

I have autoshapes (oval) in sheets 2-50, which changes color when you click
on them .
In sheet1 have a summary of sheets 2-50 (with 48 ovals)
I am trying to get the ovals in sheet1 to automatically change color to the
one selected in the corresponding sheet.

e.g. Sheet1 Oval1 = Sheet2 Oval1 (fill color)
Sheet1 Oval2 = Sheet3 Oval1 (fill Color)
and so on...

Can someone please help
T