Solved: click cell behind picture NOW EDITED

[ndendrinos]

I remember reading that this could be done in earlier versions of Excel and if memory serves I also remember trying it but that when the picture was inserted the quality of the picture deteriorated badly.
Has anyone come up with a solution to this for Excel 2000 & 2002 ?
Thank you

[mdmackillop]

Can you clarify what you're trying to do?

[ndendrinos]

I've done some progress and now CAN click a cell tha's behind a picture in Excel 2002 ...
I've also introduced this code but need to change it

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Selection.SpecialCells(xlCellTypeVisible).Select
For Each a In Selection
MsgBox "You have chosen " + a.Value


Next

End Sub


I want to set a range (i.e.) B1:G25 where the change event would work only
Instead of a message box I need to see the value of a selected cell in the above range in cell A1

[johnske]

Try from the 3rd last paragraph here > http://j-walk.com/ss/excel/odd/odd04.htm

[mdmackillop]

How did I miss such an obvious workaround! :rofl:

[ndendrinos]

So this is the article I've read in the past.
The technique Bob Umlas describes works.(no need for camera) and this is what I did.

I still need a solution to part two ......
" I want to set a range (i.e.) B1:G25 where the change event would only work,
Instead of a message box I need to see the value of a selected cell in cell A1"

[mdmackillop]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("B1:G25")) Is Nothing Then
Range("A1") = Target
End If
End Sub

[ndendrinos]

Thank you Sir , and glad to have you back.